Forum Discussion

Simon Blackburn's avatar
Simon Blackburn
Copper Contributor
Sep 14, 2017

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 the suffix 'A' so column A will read:

1051

1051A

1052

1052A........

 

I hav done this before but I cannot think how. Any guidance is greatly appreciated.

 

Thanks.

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    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.

     

Resources