Hi, new to this forum. I have been looking for a solution to this problem for sometime but cannot ever seem to get anything that works. So thought I would just post it here and see if anyone can help me. Thanks in advance.
I am trying to extract numbers from a string between the letter x. So if column A was the input, B, C and D would be the corresponding outputs.
A B C D
1 90x90x7 90 90 7
2 120x90x8 120 90 8
3 150x150x12 150 150 12
I know of the deliminator function does this, however I cant use this and I am looking for formulas that would work in its place.
Cheers.
Bookmarks