Re: [libreoffice-users] replace and text to number but no errors

Is it always the value 165.56 or do the numbers vary. If they vary does 
the number of digits vary, if not the VALUE of the LEFT() function could 
be used.
Another flexible solution would be to extract the .number with the REGEX 
function.

On 15/07/2025 11:26, James wrote:
> I have text cells that contain "165.56 MB" or nothing.
> I use this formula to get the number:
> =VALUE(SUBSTITUTE(C61,"MB",""))
> The problem is some of the cells don't contain MB and then return 
> "Err: 502".
> I want to sum the results but the Err: 502 make that fail.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy