Adding digits

  • Thread starter Thread starter pjamorton
  • Start date Start date
P

pjamorton

Hello! In a cell, I have "AME 013". I want to insert "623" to the
beginning of that cell, so the result will look like "623AME 013". How
do I go about doing this? Obviously I have a ton of them to do
otherwise I would just type it in! Thanks in advance! Jen
 
Assuming your "AME 013" is in cell A1, enter this formula in a helper
column:

="623"&A1

and copy the formula down for as many entries as you have in column A.

You can fix the values if you want using Paste Special.

Hope this helps.

Pete
 
in an adjacent cell
="623"&A1

copy down, select the second column, copy to the clipboard
goto menu Edit>PasteSpecial, click the Value button, OK out

delete the original column.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

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

Entering digits in a cell with numbers already inside cell 4
How to delete rows automatically with values zero out? 3
Inserting a hyphen after the 3rd character 3
Adding recognised Zeros 5
Replacing a last digit to something else 6
Excel Problem 2
Excel Converting Total tons into ponds per Yard 0
how to show whether 3 cells within a row match 3 cells in another 3

Back
Top