What kind of character is in between the values? i.e. If it is a TAB
than use the Search function for the tab character w/in a MID function.