zendog1960
Active Member
- Joined
- Sep 27, 2003
- Messages
- 459
- Office Version
- 2019
- Platform
- Windows
I have a column of values that are like follows:
Column D
6'
36'
110'
etc
I have the same situation in column E as well. In column F I would like a formula that will add both values in Column D & E in each row. How do I get around the " ' " foot indicator with each value? Keep in mind that I have some 32 worksheets to go through.
THanks so much in advance!
Zen
Column D
6'
36'
110'
etc
I have the same situation in column E as well. In column F I would like a formula that will add both values in Column D & E in each row. How do I get around the " ' " foot indicator with each value? Keep in mind that I have some 32 worksheets to go through.
THanks so much in advance!
Zen