Thread
:
Alter Account numbers
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]