Thread: How do I add text to existing text in a whole column in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
holyman holyman is offline
external usenet poster
  
Posts: 23
Default How do I add text to existing text in a whole column in Excel?
Highlight column and try 'edit' replace.

replace 'k' with 'mk/k'. Replace All

"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
Reply With QuoteReply With Quote