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

"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...

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
--
David Biddulph


"Eduardo" wrote:

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...

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...