Using non-numerical imported data

  • Thread starter Thread starter Ricardinho
  • Start date Start date
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
 
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.
 
Back
Top