Auto Fill cell help

[Jo-AnnDP]

Good day,

I am trying to "auto fill" cells - these numbers in column A should all have "21" in front:

A1 = 21112 /

A2 = 21113 /

A3 = 21115 etc.

Is there a formula I can use where I can automatically insert what ever numbers need to be in front of the current 3 numbers in each cell?

Hope this makes sense...

[#2 · Accepted solution]

Hi @Jo-AnnDP 

in B1: =--("21"&A1)

and copy down as necessary...

[#3]

thank you so much!! awesome :)

[#4]

You're welcome. Glad I could help with the easy one & Thanks for providing feedback