Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delimiting when seperator is a comma & number is bigger than 1,000
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to Calculate how much bigger one Number is than another in | Excel Discussion (Misc queries) | |||
Excel 2002 -Merging cells contents in with a comma seperator | Excel Discussion (Misc queries) | |||
Len function returns bigger number | Excel Discussion (Misc queries) | |||
Excel 2000 (9.0.6926 SP3) spreadsheet getting bigger & bigger .... | Excel Discussion (Misc queries) | |||
Insert a Seperator into a number string. | Excel Discussion (Misc queries) |