If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Removing Carriage Return characyers from a cell | bleu808 | New Users | 4 | June 22nd, 2004 01:29 PM |
Displaying hidden characters in a cell | Lezlee | Worksheet Functions | 1 | February 4th, 2004 11:08 PM |