tkroper
Active Member
- Joined
- Feb 2, 2007
- Messages
- 255
Hi all!
There must be a simple way to do this...
In column A, the cells contain strings of text which ends with a dollar sign and an hourly rate: $24.00 for example. There will always be a total of 6 characters. In column B, I would like a formula that simply isolates the dollar figure including the dollar sign from column A.
I appreciate your help on this.
Todd
There must be a simple way to do this...
In column A, the cells contain strings of text which ends with a dollar sign and an hourly rate: $24.00 for example. There will always be a total of 6 characters. In column B, I would like a formula that simply isolates the dollar figure including the dollar sign from column A.
I appreciate your help on this.
Todd