Text String help

[proctk]

HI have a spreadsheet with a list of names formated like this

12345 - FNAME1, LNAME1 (note fname1 & lname2) are not all the name number of characters.

I'm trying to get a formula that will return the following as proper text

Result = "Fname1 Lname1"

Any help is great

 

[Excelestial]

Assuming the text string is in cell E15:

=TRIM(SUBSTITUTE(RIGHT(E15,SEARCH(", ",E15,1)),", "," ",1))

 

[Excelestial]

Ooops...you wanted a proper case:

=PROPER(TRIM(SUBSTITUTE(RIGHT(E15,SEARCH(", ",E15,1)),", "," ",1)))

 

[doofusboy]

This should work:

=PROPER(SUBSTITUTE(MID(A1,FIND("-",A1,1)+2,LEN(A1)-FIND("-",A1,1)+2),",",""))

 

[proctk]

This is very close.

for some of the names it's leaving a -

example - Lname Fname

 

[proctk]

It's working......... thank you so much

 

[proctk]

darn... Just noticed that the orginal values are Lname then Fname.

Can the formula be changed some how to reverse the order

Current formula
=PROPER(SUBSTITUTE(MID(A10,FIND("-",A10,1)+2,LEN(A10)-FIND("-",A10,1)+2),",",""))

 

[proctk]

I found this to reverse the order but it leaves the last letter off

=MID(G10 & " " & G10,FIND(" ",G10,1),LEN(G10))

any thoughts

 

[Excelestial]

=mid(g10 & " " & g10,find(" ",g10,1),len(g10)+1)