deliminate

I have a text string that I need to separate out via formula. I know how to do it via the built in Delimiter, but I have to do this via formula. VBA is an option too .... The sub-strings are delimited by a comma and a space, e.g. ", " The individual sub-strings can range from 2 characters to 3...

I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore...

HI Here's my challenge: #1 - Digits must retain 4 digit value #2 - I need to merge them into one row separated by semicolon ";" <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> 0028 0298 0357 0387 0524 </TBODY> DESIRED GOAL - 0028;00298;0357;0387;0524 How do I do this w/out use...

Hi there, I have a taqble that I am getting from the internet through a web query (you can probably already telll I have pretty much no experiance with excel) and the table has a field which contains a set amount of choices, seperated by a question mark, example: hello?world?how?are?you I...