I copied some data from report and pasted into the excel the lines look something like this.
[Random Alphanumeric Chars of Varying Lengths] In=323 Out=69540 [Random Alphanumeric Chars of Varying Lengths].
What I am look to do is extract the 'In' and 'Out' values into to separate columns
I know using a series of Right and Left and Mid formulas I could do this but it would be rather messy I am querying their are any more elegant ways to do this.
As always any help is welcome.