Combining cells

Using Excel 2002:

I will open a text file into excel. This file has no formatting, but the
end result would be using two columns.

The text file for example has:
Music1 from site1 and site2 special 90876
Music100 extra from site1 87654
Music02 misc sites 10020

I want to put the numbers, 90876, 87654, 65409 in the same column "B" and
have the other text combined into one column "A". When I use space
delimited I can move the numbers in the same column. How do I combine the
rest of the text which are word for word in columns A,B,C,D etc into one
column "A"?

End result:
"Music1 from site1 and site2 special" in Column A, and "90876" would be in
column B.
"Music100 extra from site1" Col A, and "87654" in Col B.
"Music02 misc sites" Col A, and "10020" in Col B.

Hope I'm explaining this so it's understandable.

MC

Hi Mark

Try entering in another column, say column F
=A1&" "&B1&" "&C1&" "&D1 and copy down
Copy the whole of the range in column F, move to A1 and Paste Special>Values
This will overwrite what is in column A with your concatenated string of
text.
Delete columns B,C and D

BEFORE YOU START, make a copy of your data - in case of any foul ups!!!

Regards

Roger Govier



MarkC wrote:

>Using Excel 2002:
>
>I will open a text file into excel. This file has no formatting, but the
>end result would be using two columns.
>
>The text file for example has:
>Music1 from site1 and site2 special 90876
>Music100 extra from site1 87654
>Music02 misc sites 10020
>
>I want to put the numbers, 90876, 87654, 65409 in the same column "B" and
>have the other text combined into one column "A". When I use space
>delimited I can move the numbers in the same column. How do I combine the
>rest of the text which are word for word in columns A,B,C,D etc into one
>column "A"?
>
>End result:
>"Music1 from site1 and site2 special" in Column A, and "90876" would be in
>column B.
>"Music100 extra from site1" Col A, and "87654" in Col B.
>"Music02 misc sites" Col A, and "10020" in Col B.
>
>Hope I'm explaining this so it's understandable.
>
>MC
>
>
>
>
>
>