removing some of the characters from a cell

P

Patience

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!
 
G

Gord Dibben

Data>Text to Columns>Space delimited and skip the columns you don't want.

This will leave 55 in first column.


Gord Dibben Excel MVP
 
Top