ExcelBanter - Substitute to Retun a number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Substitute to Retun a number (https://www.excelbanter.com/excel-discussion-misc-queries/215028-substitute-retun-number.html)

clb

Substitute to Retun a number

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!

T. Valko

Substitute to Retun a number

Try this:

=--SUBSTITUTE(A1,"<","")

--
Biff
Microsoft Excel MVP

"clb" wrote in message
...
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!

Gary''s Student

Substitute to Retun a number

=--SUBSTITUTE(A1,"<","")
--
Gary''s Student - gsnu200823

All times are GMT +1. The time now is 05:33 PM.