Adding characters to existing column values

[Franv]

Hi
Hope someone can help.
I want to add characters to an existing column.
Below i have Column A and Column B.
Column A is given and Column B is after the characters CO has been added.
I don't know if this a macro or function.


A |B
123 |CO123
124 |CO124
125 |CO125
126 |CO126

Will appreciate any advice.
thanks in advance.

[jeffreybrown]

Place in B1 and drag down...

="CO"&A1

[dogberry]

Hi

Insert a new column A then in first cell type ="CO" &B1 then copy down.

Chris

[Franv]

Jeffrey and Dogberry thank you