Hi
Can someone help me with this issue.
How do i extract data from aaaaaa_bbbbbb_cccccccc__dddddd_eeeeeee.
The number of characters are not the same. I want to extract the characters of each "_ "
I only know how to extract the first string before "_ " =LEFT(A1;FIND("_";A1)-1)
Why not use text to columns and use the "-" as the delimiter.
HTH
Regards, Jeff
You can find the position of the second _ by using the found position of the first _ instead of where you typed -1
okay thx for the help
If your problem is solved, please mark the thread as Solved and also consider to Add Reputation
When I say semicolon, u say comma!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks