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

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

Eduardo

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
 
D

David Biddulph

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
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edit many cells at once to add a charater to existing data? 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Delete space at beginning 4
Excel Add ^ to a row of cells containing letters 3
How do I add cells by highlighting them? 2
Excel How do I delete images in a specific range 1
how to add decimal to beginning of imported number 2
Copying multiple cells out of multiple worksheets at same time. 1

Top