ExcelBanter - Remove the char from right

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Remove the char from right (https://www.excelbanter.com/excel-worksheet-functions/245329-remove-char-right.html)

Ranjith Kurian[_2_]

Remove the char from right

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

JLatham

Remove the char from right

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

Ranjith Kurian[_2_]

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

All times are GMT +1. The time now is 11:42 PM.