Hello, I have a problem that I think needs RegEx to solve and I am confounded by RegEx
I have two Identical columns A & B were some of the cell values are in th form
TextString - DifferentTextString [string]? e.g Baltimore Asthma Management - How strongly do you value your relationship with [Field-2]?
In column A I need to remove the middle part - DifferentTextString and the ? leaving TextString [string] as the cell value e.g Baltimore Asthma Management [Field-2]
And in column B I need only the middle part DifferentTextString e.g How strongly do you value your relationship with
Thanks in advance for any help on this
Bookmarks