|
| 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
May 3rd, 2005, 07:37 PM
|
|||
|
|||
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
May 3rd, 2005, 07:55 PM
|
|||
|
|||
|
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
May 3rd, 2005, 08:28 PM
|
|||
|
|||
|
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 |
Linear Mode
