Hello everyone,
I have the following question:
In a workbook I have a few rows looking like this:
LISDFGSD CD SDGSDFGSDFPLEIN 33 A 3445 EP ROTT 21555 210521/MIV 16-3-2010/DJ
DEBI 213405 IAS PLEINPLEIN 21 B 30e5 EP ROTT 18112825
There are lots of spaces, not consistent at all. Lets say the first line is A1 and the second A2. What I need is a formula in the cell next to these two lines that give me the following values:
For A1: 210521
For A2: 213405
The formula has to subtract a number which is always 6 digits long, starting with "21". It can be anywhere in the cell.
I hope I'm clear enough explaining this!
Thanks in advance,
Marco
Edit: SOLVED
Bookmarks