Extract the text before a comma but only if there is a comma

[Carl_London]

As the title says, I would like to extract the text before a comma, but there will not always be a comma, like this:

Column A gives Column B

Thank you for any help

Carl

 

[Joe4]

Put this in cell B1 and copy down:

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

 

[Fluff]

How about

=LEFT(A2,FIND(",",A2&",")-1)

 

[Carl_London]

Perfect thank you!

 

[Joe4]

You are welcome.
Glad we were able to help!