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
LVL 8
kingjelyAsked:
Who is Participating?
 
qld_motorwaysConnect With a Mentor Commented:
Hi, Select your string, Go to data- text to columns-select delimited and select comma.

Is that what you had in mind?

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

Is that what you had in mind?

Adam
0
 
kingjelyAuthor Commented:
Your a king

Thanks mate !
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
kingjelyAuthor Commented:
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
0
 
qld_motorwaysCommented:
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
0
 
qld_motorwaysCommented:
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
0
 
kingjelyAuthor Commented:
Its all good, ts not possible anyway

THanks
Jason
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.