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
|