On Aug 23, 3:20 pm, Knows nothing about formulas <Knows nothing about
wrote:
Set up a table with numbers reading like this:
1.2K 1.5M 1.8B

How can I getExcelto replace the K (or M or B) with K equaling thousand (M
equaling million and B equaling billion) to times the number it is using.

in other words, trying to convert 1.2K in the cell say 1,200. Is this
possible? And do I make sense? Thanks for your help ahead of time.

=IF(RIGHT(I14,1)="K",LEFT(I14,3)*1000,IF(RIGHT(I14 ,1)="M",LEFT(I14,3)*1000000,IF(RIGHT(I14,1)="B",LE FT(I14,3)*1000000000)))