Sperate Text

[gebo84]

Hi,

I have been given a spreadsheet which i need to use to upload data to our website, however the data i need is in a line of string text all in one cell in excel. Ideally i need the data separated into separate cells.

Example of one of the cells below:

100002;10000200;Oregon 400 ml aluminium water bottle with carabiner;Staying hydrated at all times is possible with this durable yet lightweight 400 ml aluminium water bottle. It is the perfect companion while exercising

I need everything that's separated by a comma in its own cell if that's possible. There is 10,000 rows of data that need this applying too.
Any help is much appreciated.

Thanks In Advance.

 

[SanjayGMusafir]

I need everything that's separated by a comma in its own cell if that's possible

Text to Columns is an inbuilt feature in Excel for the same purpose. Use any Delimiter that you want