I have a feild which i have exported from Crystals reports TO Excel.
The feild is a SINGLE STRING:
ADIDAS, BOTTOMS, LADIES,
How do i get excel to recognise the commas within the string, and seperate? at the moment it is seperating all commas, but as this is a single string, Excel is reading this as a single string
The reason why, is because i have a customer wanting to export this report to xcel, and stort by each column individually.
THanks for any help