One way

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


Regards,

Peo Sjoblom

"Patience" wrote:

Hi. I have a spreadsheet where attendance in classes is represented as "55 of
60." I need to add the actual # of attendees, so I need to remove the "of
60." How can I do that?
Thanks!