Forum Discussion
Copy a Cell and add a Suffix
In my table for work I have a column with duty number shown in Column A in the image. In the blank cells of Column A I want them to be filled with whatever the cell above contains but with...
Simon,
select column A.
Press F5.
Click on "Special ...".
Select "Blanks".
Click on "OK".
Type = (equal sign), press CURSOR UP, type &"A".
The formula should read =A2&"A".
Press CTRL+ENTER.