Substitute to Retun a number

  • Thread starter Thread starter clb
  • Start date Start date
C

clb

I am using the substitute function to split a cell containing <5 into two
cells: < and 5 using the following

=substitute (A1,"<","")

I need the 5 to be a number and this is causing it to be formatted as text.
Any suggestions? Thanks in advance!
 

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

Formula help 1
Split Cell Range into Multiple Cells 1
Array Substitution Based on Drop Down List 1
HOW TO DO AN IF, IN A MACRO 18
Truncate / Substitute Formulas 3
Conundrum 7
Need Help with Substitute Formulas, etc. 5
SUBSTITUTING TEXT FROM A LIST 6

Back
Top