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!

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


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