In an un-used column, say column Z, enter:

=A1 & "qwer" and copy down thru Z170

Then copy Z1 thru Z170 and PasteSpecial/Value back onto column A.

To put the characters before the orginial text, use:

="qwer" & A1
--
Gary''s Student - gsnu200810


"vcff" wrote:

Hi All

I have two worksheets with the following info.
Column A1: A170 have wordings of different length for both worksheets.

I will like to add 4 extra characters in front for one worksheet and the
opposite for the other worksheet (behind) in each cell.

Thanks

vcff