Can't do any of those unfortunately because I can't change the exporting
process & the number format varies. But I have discovered if I copy it into
word & then do a find & replace and change the comma to a different character
that seems to work. would be easier if I could do it within excel though.
Thanks for your help!
Anna
"Bernard Liengme" wrote:
1) can you change the app that exports the data to add a space after the
comma?
or
2) can you get the exporter to add a character (such as single quote) at the
start of the string?
or
3) if the numbers are always 4 digit, 3 digit, 4 digit you could format the
cells as text and extract using Fixed option.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Anna" wrote in message
...
I have a data download that is appearing in the column like this:
1021,105,1268
I am trying to delimit it to appear in 3 seperate columns like this:
1021 105 1268
But excel is reading the , as a thousand seperator & therefore treating
the
cell as a whole number ie 10211051268
Is there any way I can overwrite this, or another way I can seperate into
columns? The reason I need to is to do a vlookup on another sheet as the
above refer to product codes & I need to report on total sales for all
products.
Any help gratefully appreciated!!
Anna