Cloning Austin Powers (with modifications)

  • Thread starter Thread starter Voodoodan
  • Start date Start date
V

Voodoodan

Hi,

Does anyone know how to do the following, for example, please?

Cell A1 shows: Austin Powers, International Man of Mystery.

However I'd like cell A2 to copy the information, but delete everything
from the comma onwards automatically.

So cell A2 should show: Austin Powers

Thanks for your help,
Dan.
 
Dan,

Try the following formula. It works regardless of whether a comma exists in
A1.

=IF(ISERROR(FIND(",",A1,1)),A1,LEFT(A1,FIND(",",A1,1)-1))
 
Back
Top