I have data that where I extract numerical data but when there are decimals , it is extracting as whole number in columns B
Instead of extracting 1.5 , extracting as a whole number 15
Please Login or Register to view this content.
I have data that where I extract numerical data but when there are decimals , it is extracting as whole number in columns B
Instead of extracting 1.5 , extracting as a whole number 15
Please Login or Register to view this content.
Try this with ctrl+chift+enter
=MID(A1,MATCH(TRUE,ISNUMBER(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),0),COUNT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))+1)
Perfect Thank you for assistance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks