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 "EditPasteValues"
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



"Steve M" <Steve wrote in message
...
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