Zack
asked on
Extracting Specific Text from an Excel String
Heyas,
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.
Thank you.
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.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the help.
you could use these formulas
Open in new window
Regards