ExcelBanter - Ref a Cell, but only certain values within Q

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Ref a Cell, but only certain values within Q (https://www.excelbanter.com/excel-worksheet-functions/163512-ref-cell-but-only-certain-values-within-q.html)

Sean

Ref a Cell, but only certain values within Q

The following value is in A1: 31.65 x 8800

I then reference A1 in cell B1, except I only wish to reference the
value 'as far as' the first blank i.e. B1 above would equal 31.65.

As A1 can be 1; 2; or 3 digits and 2 decimals, I'm not sure how to do
this

Thanks

Max

Ref a Cell, but only certain values within Q

Try in B1: =LEFT(A1,SEARCH(" ",A1)-1)+0
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sean" wrote in message
oups.com...
The following value is in A1: 31.65 x 8800

I then reference A1 in cell B1, except I only wish to reference the
value 'as far as' the first blank i.e. B1 above would equal 31.65.

As A1 can be 1; 2; or 3 digits and 2 decimals, I'm not sure how to do
this

Thanks

Sean

Ref a Cell, but only certain values within Q

Thats it Max, thanks

Max

Ref a Cell, but only certain values within Q

welcome, Sean
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sean" wrote
Thats it Max, thanks

All times are GMT +1. The time now is 08:17 PM.