thematt257
New Member
- Joined
- Nov 8, 2018
- Messages
- 2
Hi,
I'm hoping you can help. I am am trying to extract a string from a cell. The string has a variable length but contains an 'x' in the middle.
An example:
A2: '100X100 Some Name For This'
A3: 'Some Name 100x200 For This'
A4: 'Some Name For This 300X10cm'
I will like to get the following results:
B2: 100X100
B3: 100x200
B4: 300X10
Is this possible?
I'm hoping you can help. I am am trying to extract a string from a cell. The string has a variable length but contains an 'x' in the middle.
An example:
A2: '100X100 Some Name For This'
A3: 'Some Name 100x200 For This'
A4: 'Some Name For This 300X10cm'
I will like to get the following results:
B2: 100X100
B3: 100x200
B4: 300X10
Is this possible?