How to extract number from cell

[Anjankumar2021]

Hi Team,

please assist to extract specific number from cell.

**remove first 8 digits 

**remove last 6 digits

Input

Product ID

2025052200786767910001-1

2005052200786768180001-1

2028052200786768690001-1

2029052200786768490001-1

2026043000755774070001-2

required output:

Output

Updated ID

0078676791

0078676818

0078676869

0078676849

0075577407

[Qiu]

@Anjankumar2021 

We can use the RegReplace formula or RegEx tool with same Regex.

[lukas_olsovsky · Accepted solution]

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 :)