thanks

Have a nice day.

vcff

"Joel" wrote:

The best way is to use a fromula in column b to add the extra characters.
You can then copy the changes back to the original column using Copy - Past
Special Values to remove the formula.

To add caharcter it is very simple

="abcd"&A1 to add abcd at the beginning of the data
=A1&"abcd" to add characters at the end of the data

"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