how to combine text into a cell???

[Guest]

there are numbers 1 to 100 on conlumn A, like A1=1,A2=2,A3=3, so on. how can
I combine all of these numbers into one cell like 123456789101112....
I know I can use =A1&A2&A3
but it is just only good for combining few of data together, any one can
tell me a good way to do this???

 

[wjohnson]

Copy the column - open a WORD Document - Paste into Word
Select the Column - then do a TABLE to TEXT.
You should have paragraph marks after each item - you might have to
"TURN-ON" view paragraph marks - the paragraph mark symbol is on the
"Standard" Toolbar.
Now go to REPLACE - then under the "MORE" - SPECIAL tab - select
paragraph mark - or type in the find box ^p - (use the number 6 key for
the ^ symbol and lower case p). Then do a replace - then in the replace
box you can enter whatever you want or leave it blank. Everything will
go to 1 line.
Copy and paste back to excel.
Easiest way I know of doing it.