Remove the char from right

  • Thread starter Thread starter Ranjith Kurian
  • Start date Start date
R

Ranjith Kurian

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
 
Second attempt.
Assume that 123-ibb is in cell A1, then in another cell put this formula:
=LEFT(A1,FIND("-",A1)-1)
 
super dude, its working fine and thanks a lot

JLatham said:
Second attempt.
Assume that 123-ibb is in cell A1, then in another cell put this formula:
=LEFT(A1,FIND("-",A1)-1)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Duplicates logic 2
removing commas from numbers etc. 2
Conditional Formatting from a group 6
Vlookup question 1
using a function to insert symbol 1
Range name of "\0"? - How can I slide this past Excel? 3
MID function 6
Wrong result from formula - please evaluate 5

Back
Top