input text at front of field that contains data

[Guest]

Hi there,

I have imported data into excel and I wish to input text ZZ in front of the
orginal data...for example her is how the data looks like(to the left).

Column A (how do I put a ZZ in front of the text without going through it
one by one
________ so in a matter of seconds it should look like this(the column to
the right)
ABADES ZZABADES
ABADEF ZZABADEF
ABADET ZZABADET
ABADER ZZABADER
ABADEW ....and so on
....and so on

I have 6211 rows to input "ZZ" infront of the original text...what is the
fastest way to do this? Please Help

cheers
Steve M

 

[William]

Hi Steve

1) Insert a new column before column A so the new column becomes Column A.
2) In cell A2 (assuming your data starts in cell B2) enter the formula
="ZZ"&A2
3) Copy cell A2 down as far as you need.
4) Select all of Column A and "Edit>PasteValues"
5) Delete Column B (or copy Column A to cell B1 and delete Column A)

If you want a macro to do this, please post back.
--


XL2003
Regards

William
(e-mail address removed)

 

[Dave Peterson]

How about a formula in B1 dragged down to B6211.
="ZZ"&A1

 

[Ragdyer]

How about the same formula in B1, but instead of dragging down 6,000 plus
row, just double click on the fill handle?

Hope there's no spaces.<g>