repeat last step

A

alexshields

Dear Excel Friends,

I'm working on a sheet that I need to cut and past the same text
(words) into one column. There is already a number in each cell that I
want to keep. Basically the number follows the text in each cell... so
that the end result is one colmn with all the same paragraph with a
unique numbers at the end of each generic bit of text. This sheet has
700 entries so it's kinda long and tedious. Is there a quick way to
repeat this step or smash the whole column out in one shot.

Cheers, Alex
 
K

Ken Wright

Assuming your data is in A1:A1000, in cell B1 put =A1&" All your text"

Now copy down to B1000. Copy Col B and paste special as values then just
replace Col A with B. Doesn't have to be B can be any handy column. Now delete
B.

When done simply select Col A do format / cells / Alignment and uncheck wrap
text.
 
A

Allan S. Warrior

Initially, put the text in a different column than the number; if it's the
same text for all rows, you can probably Fill Down or paste once into all 700
rows. (Format|Cells|Alignment no text wrap will keep the text on one line to
answer your other post).
Then use a concatenation formula to combine your text and numbers in a
different column: if the text is in column j and the number in cell f3, the
formula would be =j3&f3. If you need space between, =j3&" "&f3. Run that
formula down the rows with Edit fill down or paste.
Finally, select that lot, copy it, and paste into a final column using Edit
Paste Special, and paste only the Values.
Delete any columns you don't need anymore.
Good luck!
 
Top