I am composing a workbook, and the problem is the amount of input I need to
do, I have 276 rows and will probably have about the same number of columns,
The details I'm entering is as the example HA002030 then HA002030 in the next
row of same column. I finished one column and thought I would copy the column
and paste it in the subsequent columns and then change the first 2 letters,
which would save me some inputting, I thought I would be able to change the
first two letters by using replace but it won't let me do it, does anyone
have a suggestion how I can change the first two letters in the other
columns. The next column would be HB then HC and so on.
Alan