A
Anna
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
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