Remove the char from right
super dude, its working fine and thanks a lot
"JLatham" wrote:
Second attempt.
Assume that 123-ibb is in cell A1, then in another cell put this formula:
=LEFT(A1,FIND("-",A1)-1)
"Ranjith Kurian" wrote:
i need a excel function to remove the character from right, and its been
identified by the symbol "-", example as shown below
QUESTION:
Code
123-ibb
US456-europ
UKASDGG-1234HR
ANSWERS:
Code
123
US456
UKASDGG
|