# Formula to isolate last 6 characters in text

#### tkroper

##### Active Member
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

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### dafan

##### Well-known Member
=RIGHT(A1,6)

Indeed pretty easy :P

#### debooo

##### Board Regular
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

##### Active Member
Indeed! Thanks again dafan!

Thank you to you also debooo!

#### dafan

##### Well-known Member
No worries man, keep m coming

#### schielrn

##### Well-known Member
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

##### Active Member
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).

Todd

Replies
3
Views
138
Replies
2
Views
77
Replies
10
Views
384
Replies
1
Views
132
Replies
2
Views
108

1,191,709
Messages
5,988,236
Members
440,139
Latest member
ngaicuong2017

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back