Cut/Past Currency is Text

R

RzB

I have cut and pasted some data into excel from a web page.

It sorts out the columns just fine. However one of the columns
is a list of currencies but Excel it treating it like text. Each cell
has a leading £ and a couple of trailing blanks. As it is text I am
unable to sum etc. Is there some way to simply overcome this...

Many thanks,
Roy
 
N

Norman Harker

Hi Roy!

Select the column of data and use:

Data > Text to Columns
Check fixed width
Next
Insert a divide after the currency symbol
Next
Finish

You can then delete the first column.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

RzB

Oooo - That's interesting - Didn't know about that feature...
However - it's not quite fixed the problem... Yes, it's
got rid of the currency symbol but I still have the two
trailing blanks. I can't do the same trick with the blanks
because some of the numbers are longer than others.
I tried right justifying first but that didn't help...
Any other thoughts?
Many Thanks,
Roy
 
N

Norman Harker

Hi RzB!

Select an Empty cell
Copy
Select the entries you have
Edit > Paste Special > Add > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top