View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default How do I Add Data at the beginning of multiple cells in Excel?

Hi,
let's assume your data is in column A, then in another column enter

="PH"&A1

copy formula down, if you want an space between PH and the data use

="PH"&" "&A1

"Leigh" wrote:

I have an excel document that I am trying to add the letters "PH:" in front
of already existing data (phone #'s) to help create a directory of sorts...
Need to know if theres a way add this at the beginning of data in multiple
cells all at once?
Any help is appreciated...