How do I Add Data at the beginning of multiple cells in Excel?

  • Thread starter Thread starter Leigh
  • Start date Start date
L

Leigh

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...
 
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
 
If you want a space, ="PH"&" "&A1 may be better than ="PH "&A1, but if you
want a colon as originally requested, try ="PH:"&A1
 
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...>Values>OK
-- delete column B

Regards,
Fred
 
Back
Top