Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below formatted cell..I want to extract numbers after the first 8 digits.I tried the below expression but it is eliminating 0's at the end and also there are some that are getting eliminated in the middle.
mid(Num(Replace(key, ',', '.'), '(dec)'),9) - Output is 1800010
Is there any other work around for this please ?
Thank you much.
try converting it first to text and then extract the string
mid(text(Replace(key, ',', '.')),9)
or
mid(text(Num(Replace(key, ',', '.'), '(dec)')),9)
Thank you Khush - I tried this, but no luck..output is same as above.
I have attached the sample file, if that helps.Thank you much.