Comma Delimited Merging..

[vampcatt]

I have a couple text files that are comma delimited that I have imported into excel.

My problem is that a handful of the rows had "extra" commas.. resulting in extra columns.

example:

San Jose, CA, shirts, orange, green, blue,

In that case, I'd want to merge "orange, green, blue" into one cell.

Is there a function to perhaps highlight the columns side by side and merge them all into ONE cell "orange green blue"

Thank you in advance for your help.

 

[Matt]

Once the data has been imported, you can use the concatenate formula,

e.g.,

=CONCATENATE(A1,",",B1,",",C1)

where A1 to C1 contain your colours

HTH

Matt
This message was edited by Matt on 2002-03-10 15:06

 

[Jack in the UK]

Hi ==

Worth a look at :CONCATENATE should do as you ask..

=CONCATENATE(Rng1, " ",Rng2, " ",Rng3)

Use the wizard if needs be can be any rng (range but single cell at a time thou) will just string them together for you.

 

[vampcatt]

I tried the concatenate

"e.g.,

=CONCATENATE(A1,",",B1,",",C1) "

BUT.. I dont wish to have the seperate cells in the document anymore.

That does work to merge the cells, but then I wind up with

color color color , color, color, color
I only want the "color color color" in there.. if I remove the sperate cells, then of course excel doesnt have that data to reference to.

Is there no way to "merge" them without having them still there to reference ?

 

[Skebo]

You can do the =CONCATENATE(A1,",",B1,",",C1)
and then copy the values from the concatenate to another column using 'paste special' with the values option set.