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