LinkBack URL
About LinkBacks
I have cell data as follows.
BUC250_abcedf_ghtt
I want to spilit it by the first _ ,and put the first part of the value in to the Adjacent cell as attached.
Out should be as follows
BUC250
I have cell data as follows.
BUC250_abcedf_ghtt
I want to spilit it by the first _ ,and put the first part of the value in to the Adjacent cell as attached.
Out should be as follows
BUC250
Last edited by naflas; 11-22-2010 at 07:45 PM.
Try:
=LEFT(A1,FIND("_",A1,1)-1)
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks