Alter Account numbers
I have a list of approx 9000 account numbers that are in the format:
#####-###-### (ex: 35000-455-876) I would like to add "03-" to the front of the numbers and delete the last "-###", so the final format would be: 03-#####-### (ex: 03-35000-455) Any suggestions? I can't seem to figure out the concantenate function. Thanks! Ann |
Alter Account numbers
Ann,
Assume data is in A2 then in b2 put: ="03-" & LEFT(A2,9) Change cells(Columns) as needed and copy this formula as required. HTH "Ann" wrote: I have a list of approx 9000 account numbers that are in the format: #####-###-### (ex: 35000-455-876) I would like to add "03-" to the front of the numbers and delete the last "-###", so the final format would be: 03-#####-### (ex: 03-35000-455) Any suggestions? I can't seem to figure out the concantenate function. Thanks! Ann |
Alter Account numbers
or a macro to do all
Sub fixnumbers() '="03-" & LEFT(A2,9) For Each c In Selection c.Value = "03-" & Left(c, 9) Next c End Sub -- Don Guillett SalesAid Software "Toppers" wrote in message ... Ann, Assume data is in A2 then in b2 put: ="03-" & LEFT(A2,9) Change cells(Columns) as needed and copy this formula as required. HTH "Ann" wrote: I have a list of approx 9000 account numbers that are in the format: #####-###-### (ex: 35000-455-876) I would like to add "03-" to the front of the numbers and delete the last "-###", so the final format would be: 03-#####-### (ex: 03-35000-455) Any suggestions? I can't seem to figure out the concantenate function. Thanks! Ann |
Alter Account numbers
Thanks! That was so incredibly easy! I was trying to make to much work of it.
Thanks, Ann "Toppers" wrote: Ann, Assume data is in A2 then in b2 put: ="03-" & LEFT(A2,9) Change cells(Columns) as needed and copy this formula as required. HTH "Ann" wrote: I have a list of approx 9000 account numbers that are in the format: #####-###-### (ex: 35000-455-876) I would like to add "03-" to the front of the numbers and delete the last "-###", so the final format would be: 03-#####-### (ex: 03-35000-455) Any suggestions? I can't seem to figure out the concantenate function. Thanks! Ann |
All times are GMT +1. The time now is 02:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com