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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
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.
 
Back
Top