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