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
 

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

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
Format cell to always begin with an "X" 2
Edit many cells at once to add a charater to existing data? 3
Delete space at beginning 4
Stepping in to a cell 3
How do i prevent the 000's in the beginning of an entry from dropp 7
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
How do I add cells by highlighting them? 2

Back
Top