How do I add text to existing text in a whole column in Excel?

R

Robin Laverick

I have a column of data e.g.
k2747whi
k4870whi
k4871whi
and I need to add the same text to the start of the entire column to achieve:
mk/k2747whi
mk/k4870whi
mk/k4871whi
Any ideas?
Thanks
 
M

Marcelo

hi, with an auxiliar column, lets say B (assuming your data are on A), use

="mk/"&a2

copy it down

hth
regards from Brazil
Marcelo

"Robin Laverick" escreveu:
 
L

Lanka Suri

Concatenate your existing coloumn with an adjacent column by using the
following simplification. ="mk/"&a1 in any coloumn and replicate the
result. Finally copy and special paste it in another coloumn. Surely it can
work for you.
 
Top