Add Add'l Numbers to Existing Numbers in Cell

B

beirrac

New Member
Joined
Jul 20, 2007
Messages
45
Hi,

I have a problem where I need to be able to change existing numbers in a column by adding additional, consistent numbers. Currently, I have 4 digit alpha-numeric and need to change them to 10 digit alpha-numeric. I need to add the number "9" before the existing number, and the numbers "00000" to the end of the existing number. For example:

A1 Number
A2 850C needs to be 9850C00000
A3 4321 needs to be 9432100000
A4 5621 needs to be 9562100000

Any good ideas so I don't have to do this manually on hundreds of columns?? Appreciate any assistance.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Try this.

If column a is the alpha-numeric,
Then put this in the cell you want the finished product.


="9"&a1&"00000"

Hayden
 
Upvote 0
No need for that my friend. I am always learning from these great people. You shouldn't feel stupid, you should feel impowered (or is it empowered - or neither?).

Take Care,
Roger
 
Upvote 0
You must log in or register to reply here.

Similar threads

Livin404
  • Solved
Random numbers add pointless decimals at end of whole number
Replies
4
Views
111
Livin404
Livin404
C
  • Question
Extracting Number String from a Text String Cell
Replies
9
Views
777
Glenn Kennedy
G
C
  • Question
Comparing 3 tables to a list of numbers, if match, return 4 columns worth of data on another tab
Replies
4
Views
67
alansidman
A
R
  • Question
2 column lookup formula to reference new data
Replies
1
Views
160
awoohaw
awoohaw
M
  • Question
Add in VBA Code to check zip code against pre-determined list
Replies
0
Views
145
mikefisher
M

Forum statistics

Threads
1,214,624
Messages
6,120,591
Members
448,973
Latest member
ksonnia

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top