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

Say your phone numbers are in column A, starting at A2.

-- Insert a new column B
-- Enter this formula in B2: ="PH:"&A2
-- Copy this down the length of your column.

If you like both columns, keep them. If not,
-- copy column B
-- right-click on column A, choose Paste Special...ValuesOK
-- delete column B

Regards,
Fred

"Leigh" wrote in message
...
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...