Formula to isolate last 6 characters in text

[tkroper]

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

 

[dafan]

=RIGHT(A1,6)

Indeed pretty easy :P

 

[debooo]

i think you only need to use either a right or mid formula. not sure which way you want to go but =right(A1,6) would give you the first 6 digits of A1 starting from the far right.

 

[tkroper]

Indeed! Thanks again dafan!

Thank you to you also debooo!

 

[dafan]

No worries man, keep m coming

 

[schielrn]

If it is ever 5 or 7 or any characters other than 6 you can use:

=mid(A1,find("$",A1),len(A1))

Hope that helps.

 

[tkroper]

If it is ever 5 or 7 or any characters other than 6 you can use:

=mid(A1,find("$",A1),len(A1))

Hope that helps.

Thank you schielrn! In this case, no it will always be 6. But I'm sure I'll need your solution sooner or later (I'm working on a bunch of stuff).

I appreciate your help!

Todd

 

[tkroper]

No worries man, keep m coming

Okay...http://www.mrexcel.com/forum/showthread.php?p=1604968#post1604968