input text at front of field that contains data
 

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

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

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



Steve M wrote:

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

--

Dave Peterson

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
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
How about a formula in B1 dragged down to B6211.
="ZZ"&A1



Steve M wrote:

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

--

Dave Peterson