ISERROR with Value function

[Celticshadow]

Hi All

I am using the value function to convert possible text to a number in col A, however can I use the ISERROR function within this also as some cells are blank and with the Value function return #value as below.

Text Values	With Value Function Returns as below	Data Required possibly using ISERROR
7.15	7.15	7.15
	#value
7.15	7.15	7.15
	#value

<tbody>
</tbody>

Thanks in advance.

Regards

 

[mvsub1]

Maybe try using the IFERROR function:
=IFERROR(VALUE(A1),"")

 

[Firefly2012]

If you are using xl2003 or below (and thus are unable to use IFERROR) perhaps:

=IF(A1="","",VALUE(A1))

If you just want to do everything at once, you should be able to use Data>TextToColumns on column A (ie select the entire column then Data>TextToColumns>Finish) which can work on the entire column at once (no formulas involved)

 

[Celticshadow]

Maybe try using the IFERROR function:
=IFERROR(VALUE(A1),"")

Hi mvsub1

Many thanks for replying and am delighted to say that the above formula works perfectly. I was unaware there was an iferror function so something else learned also. Thanks again.

Regards