SO is celebrating unicorn awareness day! :D
unix.stackexchange.com
=IF(REGEXMATCH(H1,"M$"),VALUE(REGEXEXTRACT(H1,"[\d\.]*")*1024^2),0)
apple.stackexchange.com
fpu-