Hi.
I am working on one file. I want to capture the string which is left and right of the delimiter "_". I dont want to use the excel inbuilt"text to column" function. Is there any function which can provide me the same result.
For Example
in Cell A1 the string is G26879_7896
I want to get G26879 in one cell and 7896 in another
Thanks in advance for the help
Bookmarks