moving name initial from back to front of cell

[spoogehead]

Another one for the gurus.....

I have a list of names in column A in the form of:

Brown, J
Smith, P

etc

I want to change all the names in the column so they are of the form:

J Brown
P Smith

ie, first initial at the front and the comma removed

Thanking you in advance

 

[Sthrncali]

Assuming your values are stored in ColA:

=CONCATENATE(RIGHT(A1,1)," ", LEFT(A1,FIND(",",A1,1)-1))

 

[spoogehead]

Genius!

Thank you so much

 

[Scott Huish]

=right(a1)&" "&left(a1,len(a1)-3)