Hi! help with finding text in string

[carura]

Hi I have to deal with a bunch of names and there is no standard format for them.
For Example;

Rizal,Jose Mercado Realonda


I need to extract the first name of this person.
The first name is right after the comma and there is no space in between.
I can't figure out a formula/function to use for this.

Please help!
Thanks!

 

[Prashod]

Try this

=TRIM(LEFT(A1,FIND(",",A1,1)-1))

 

[mmmarks]

Say data is in A1
paste this formula in A2
=RIGHT(A1,LEN(A1)-FIND(",",A1))

hope it works

 

[carura]

Hi!!
Thanks for the reply!!

MMMarks, you have the closest answer to my query.

But Im getting the whole name after the comma

I get "Jose Mercado Realonda"

I was hoping you can help me figure out a formula just to get the first word right after the comma.

Example: I just want to get "Jose"
<table x:str="" style="border-collapse: collapse; width: 306pt;" border="0" cellpadding="0" cellspacing="0" width="408"> <col style="width: 306pt;" width="408"><tr style="height: 12.75pt;" height="17"><!--StartFragment--></tr> </table>

 

[Prashod]

=right(trim(left(a1,find(" ",a1,1)-1)),len(trim(left(a1,find(" ",a1,1)-1)))-find(",",trim(left(a1,find(" ",a1,1)-1))))

 

[carura]

Prashod!!!
You're the best!! Thank you!!!


Whoopiee!!!