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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to delete first n chars
Just to clarify my original question, I'm looking for a formula
that will return a substring or a truncated substring of a given text cell. Specifically, I want to return a substring which removes the first N characters of a given text cell. Hope that is more clear! "Robert Crandal" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to delete first n chars
not sure if this is what you're looking for, but look at the mid function
=mid(a1,2,len(a1)) -- Gary Keramidas Excel 2003 "Robert Crandal" wrote in message ... Just to clarify my original question, I'm looking for a formula that will return a substring or a truncated substring of a given text cell. Specifically, I want to return a substring which removes the first N characters of a given text cell. Hope that is more clear! "Robert Crandal" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to delete first n chars
Yep, that's it! I knew it was going to be something simple!
thank u "Gary Keramidas" <GKeramidasAtMSN.com wrote in message ... not sure if this is what you're looking for, but look at the mid function =mid(a1,2,len(a1)) |
Reply |
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 |