| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove last character in a series of different length part #'s
Hi leo,
This removes the last charachter =LEFT(A1,LEN(A1)-1) This removes the last charachter only if it is a "v" =IF(RIGHT(A1,1)="v",LEFT(A1,LEN(A1)-1),A1) Ed Ferrero http://www.edferrero.com i have a series of part numbers in a column in xl that vary in length but all end in "v'. I want to remove just the "v". I tried text to coulmns and all the functions i know. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
| How do I remove all text in a cell after a specific character? | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| Remove Legend Series | Charts and Charting in Excel | |||
Threaded Mode
