| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| Create a formula to remove text to the left of specified char? | Excel Worksheet Functions | |||
| CHAR(10) | Excel Worksheet Functions | |||
| How do I remove Char(160) from a cell? | Excel Worksheet Functions | |||
![Ranjith Kurian[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
