| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to delete first n chars
I need a formula which will delete or remove the first N
(or leftmost N) characters from a text cell. I tried looking at the left() and right() formulas, but they KEEP the left or right data, rather than delete. thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to truncate list of meaningful words greater than 15 chars tomeaningful words of 8 chars. | Excel Worksheet Functions | |||
| sum first 2 chars if 3rd is something... | Excel Discussion (Misc queries) | |||
| UDF Can't return more than 255 chars??? | Excel Programming | |||
| determine if ea value in a col has more than 20 chars | Excel Discussion (Misc queries) | |||
| Removing last three chars | Excel Programming | |||
Threaded Mode
