Hi,
If you could look at the attached example...
I show what the original data looks like and what the desired results should be.
Is there a way to make this happen with a formula.
I have used text to columns for the "x" and "-" but there seems to be residual space left over before the "x".
I don't want to use a "space" as a delimiter because it will separate the column to much, so maybe a formula would be better.
What kind of formula can be used for the results displayed?
Thanks alot.
Bookmarks