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: [email protected]
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
