removing some of the characters from a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumProduct Help 4
IF conditional for 3 conditions? 3
Query for specific characters in a spreadsheet 1
Excel Need Countifs Formula Help 0
Help with Look-up Function! 1
Divide a range of cells by a number 3
remove alpha or non-numeric characters from cell 8
formula to display cell address 2

Back
Top