Parse text & numbers & format

D

dmiami

Hi,

thanks for the help, I need to clean up some data in excel,
I need to strip the letter and format the numbers.

i.e. (B=Billion M=Million)

9.965B = 9.965.000
90.965B = 90.965.000
900.965B = 900.965.000
2.1M = 2.100
20.1M = 20.100
200.1M = 200.100

There will always be 3 decimals with the B
ex. 9.965B

There will always be 1 decimal with the M
ex. 2.1M

Also, there is an empty space before the first
number, to the left in the cell.


Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fraction to Decimal 2
Convert 1.1B to 1,100,000.00 5
Selecting the first sentence of multiple paragraphs in Word 2007 2
Conditional Formatting from a group 6
Automatically chnage number format of a range of cells 2
Custom Formatting 2
cell custom format 1
Concatenate cells with text and numbers/decimals 2

Top