I have an issue where I need to do a comma delimited in Excel, however I do not want all the commas to be copied over.
For example, the data I have I want to fit into 5 columns, however in a name there could be a extra comma which increases my lines further than I want. Sporting this out one by one is taking a long time as we have loads of data to filter through.
Example.
Place, Name, Colour, Type, Amount
London, George, Smith, Green, Sparrow, £20
Bradford, Rebecca Smith, Red, hawk, £55
Leeds, Cuthbert, Morris, Blue, Sparrow, £25
I would need something to do a comma delimited, but any extra commas that do not fit it into the 5 columns need to be combined to the name column.
Is there some wizardry that could help me out here, it would be greatly appreciated.
Thanks in advance!
Bookmarks