# Smart Count\Conversion

#### tcarterg

##### New Member
I have a column that looks like this:
 1.77 T 600.40 B 33.61 B 1.36 T 50.00 B

<tbody>
</tbody>

T = trillion
B = billion

I'd like to convert these into complete numerical values, any ideas?

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
=IF(RIGHT(A1,1)="T",(LEFT(A1,SEARCH(" ",A1))*1000000000000),(LEFT(A1,SEARCH(" ",A1))*1000000000))

If your data is not in A1 then change that to suit.

Works perfectly! Ty

Replies
6
Views
174
Replies
3
Views
593
Replies
4
Views
333
Replies
8
Views
361
Replies
11
Views
2K

1,196,102
Messages
6,013,466
Members
441,767
Latest member
Craigh4444

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