How to extract number from cell

Question

Hi Team,

please assist to extract specific number from cell.

**remove first 8 digits

**remove last 6 digits

InputProduct ID2025052200786767910001-12005052200786768180001-12028052200786768690001-12029052200786768490001-12026043000755774070001-2

required output:

OutputUpdated ID00786767910078676818007867686900786768490075577407

lukas_olsovsky · Accepted Answer

Hi @Anjankumar2021  I would use formula tool for that - with left, right function. There is a also function "trimLeft" / "trimRight" but it didn´t work for your sample.

Try by yourself :)