Adding a prefix to a rane in a column

[nscherneck]

I have a series of cells in a column that i need to add a two letter prefix to. Is there a way to do this other than one by one?

[darkyam]

If it's the same prefix you can do ="AB"&A1 and drag down.
If they're different, have the prefixes listed in B1 and do =B1&A1 and drag down.

[nscherneck]

darkyam, thanks for replying. i'm sorry, i'm not vry excel savvy. i don't understand what you mean by "AB"&A1.

[darkyam]

"AB" is an example of your two-letter prefix. Adjust to suit. & is Excel's concatenation symbol. It simply joins what's before it to what's after it. If A1 has 9035, for example, and B1 has AB, =B1&A1 returns AB9035.

[nscherneck]

Great! Got it to work. Thanks for the help.