#1   Report Post  
Old March 1st 07, 08:19 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 11
Default Adding digits

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


  #2   Report Post  
Old March 1st 07, 08:32 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default Adding digits

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

On Mar 1, 7:19 pm, wrote:
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



  #3   Report Post  
Old March 1st 07, 08:33 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,593
Default Adding digits

in an adjacent cell
="623"&A1

copy down, select the second column, copy to the clipboard
goto menu EditPasteSpecial, 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)

wrote in message
ups.com...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding extra digits to columns Graham at Mac's Excel Discussion (Misc queries) 2 August 21st 06 11:24 AM
adding extra digits to columns Muhammed Rafeek M Excel Discussion (Misc queries) 0 August 21st 06 10:35 AM
adding digits of a number dantee Excel Worksheet Functions 8 March 30th 06 11:05 PM
Adding digits in a single cell stevo Excel Worksheet Functions 2 February 14th 06 12:58 PM
adding digits to front/end of fax numbers Luke Excel Discussion (Misc queries) 2 April 27th 05 11:35 PM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017