Separating contents with Comma

[Andrew.Trevayne]

Hello again,
I would like to ask help once more.
Not sure how to do this.

A1 = Trevayne, Andrew

Is it possible to get a return

A2 = Andrew

What I basically want to do is removed the last name, the separator between the firstname
and the last name is the comma ","
Hope somebody would be able to help.

Thanks in

[TMS]

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

Regards

[Andrew.Trevayne]

Perfect! Thanks so much very very much ^^

[Andrew.Trevayne]

Hello ^^
I have re-opened my post, i celebrated too soon haha!
Apparently it is only working on my example.
If I used a different name it's not working as it's supposed to be.

Is it possible to get a return where all the words after the comma will be displayed?
On my example:
A1: Trevayne, Andrew
A2: Andrew

Which is working..
But when I get longer names I dont get the whole result.
For Example
A1: Mohammad, Mohammad
the result is only
A2: Mohamm

Is it possible to capture all the words succeeding the comma?
Thanks again.

[TMS]

Please post the formula which is not working and the contents of the cell it is operating on.

If the name you are checking is in cell A1, then it should work. Note that bot cell references are the same. I suspect that, in this case, the second reference is still A1.

Regards

[zbor]

Here, try this:

Please Login or Register  to view this content.

[Andrew.Trevayne]

Wow! That solved the thing. Thanks for the help guys, really appreciate it ^^

[Cutter]

Just for the record, there was nothing wrong with the formula given by TMShucks.

It worked just fine when I tried it for Mohammad, Mohammad

[Andrew.Trevayne]

Hi Cutter,
I tried it again and got the right return, i dont understand why earlier i was getting a different result.
Anyways both solution worked perfectly and I am very grateful for the continued help Im getting from the guys here. You all deserve a thank you from ordinary Excel user as myself.
Thanks so much everyone. ^^