ukdane
12-01-2008, 11:06 AM
Quick question.
If I have a cell (A3) which reports the string "Something 30 Something 40".
The words "something" are variables so can be of any length, what formula would I use to report the number after the first space (in this instance 30) and what would I use to show after the second space (40)? The numbers 30 and 40 are just examples, and could be any number between 1 and 99999.
Just to make it a bit more complicated, is there an additional solution if the "Something" strings contain spaces as well?
The only constants are the fact that the maximum length of the string is 83 characters
Is there anyway that a formula can filter and report numbers only?
(In the same way that Trim removes blank spaces at the start of a string).
If I have a cell (A3) which reports the string "Something 30 Something 40".
The words "something" are variables so can be of any length, what formula would I use to report the number after the first space (in this instance 30) and what would I use to show after the second space (40)? The numbers 30 and 40 are just examples, and could be any number between 1 and 99999.
Just to make it a bit more complicated, is there an additional solution if the "Something" strings contain spaces as well?
The only constants are the fact that the maximum length of the string is 83 characters
Is there anyway that a formula can filter and report numbers only?
(In the same way that Trim removes blank spaces at the start of a string).