?
Solved

Excel Question

Posted on 2009-12-16
7
Medium Priority
?
193 Views
Last Modified: 2012-05-08

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
0
Comment
Question by:kingjely
  • 4
  • 3
7 Comments
 
LVL 1

Accepted Solution

by:
qld_motorways earned 2000 total points
ID: 26068876
Hi, Select your string, Go to data- text to columns-select delimited and select comma.

Is that what you had in mind?

Adam
0
 
LVL 1

Expert Comment

by:qld_motorways
ID: 26068877
Hi, Select your string, Go to data- text to columns-select delimited and select comma.

Is that what you had in mind?

Adam
0
 
LVL 8

Author Closing Comment

by:kingjely
ID: 31667149
Your a king

Thanks mate !
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 8

Author Comment

by:kingjely
ID: 26069100
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
 
LVL 1

Expert Comment

by:qld_motorways
ID: 26069194
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
 
LVL 1

Expert Comment

by:qld_motorways
ID: 26069195
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
 
LVL 8

Author Comment

by:kingjely
ID: 26069348
Its all good, ts not possible anyway

THanks
Jason
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question