asked on

Excel Question

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
Jason

ASKER CERTIFIED SOLUTION

qld_motorways

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

qld_motorways

Hi, Select your string, Go to data- text to columns-select delimited and select comma.

Is that what you had in mind?

Adam

kingjely

ASKER

Your a king

Thanks mate !

kingjely

ASKER

Hi can you check my Excel question again, i just asked again, what you did worked, but it over writes the new feilds instead of inserting them?

Is there a way to insert the 2 new feilds instead of coping over the top?

I have asked the same question again, and 500 new points

thanks
Jason

qld_motorways

hi,
can you grab all the data in the destination fields and move it a few cells to the right?
ie- if your string is in A,1 and is three words long, you can move the data in B,1 across three cells to the right (E,1) so when you split your string, its no longer in the destination cells and wont be replaced.

Let me know how you go.
Adam

qld_motorways

kingjely

ASKER

Its all good, ts not possible anyway

THanks
Jason