Using non-numerical imported data

R

Ricardinho

When importing data from financial websites, some of it
comes in as 171.1Mil instead of 171.1 , which means Excel
won't recognise it as a figure and I can't manipulate it.
Any suggestions? thanks
 
A

Andy B

Hi

You could use Data/Text to columns to split off the text bit, or use
=--LEFT(E14,LEN(E14)-3) to trim it off.

Andy.
 
Top