removing some of the characters from a cell
 

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!

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!

DataText to ColumnsSpace delimited and skip the columns you don't want.

This will leave 55 in first column.


Gord Dibben Excel MVP


On Tue, 3 May 2005 11:37:05 -0700, "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!