How do I reverse name order from Last, First to First Last in Exc

I received a file from an outside vendor with names listed Last, First. I
need to print labels for mailing from this file with names First Last. Is
there a way to reverse the order in an Excel spreadsheet?

=MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
--
Gary's Student


"Annie Lord" wrote:

> I received a file from an outside vendor with names listed Last, First. I
> need to print labels for mailing from this file with names First Last. Is
> there a way to reverse the order in an Excel spreadsheet?

Thank you so much!! That saves me enormous amounts of time. A

"Gary''s Student" wrote:

> =MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
> --
> Gary's Student
>
>
> "Annie Lord" wrote:
>
> > I received a file from an outside vendor with names listed Last, First. I
> > need to print labels for mailing from this file with names First Last. Is
> > there a way to reverse the order in an Excel spreadsheet?

You are very welcome.
--
Gary''s Student


"Annie Lord" wrote:

> Thank you so much!! That saves me enormous amounts of time. A
>
> "Gary''s Student" wrote:
>
> > =MID(A1 & " " & A1,FIND(" ",A1,1),LEN(A1))
> > --
> > Gary's Student
> >
> >
> > "Annie Lord" wrote:
> >
> > > I received a file from an outside vendor with names listed Last, First. I
> > > need to print labels for mailing from this file with names First Last. Is
> > > there a way to reverse the order in an Excel spreadsheet?