How do I add text to existing text in a whole column in Excel?
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.
"Robin Laverick" wrote:
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
|