Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function/Macro that keeps first X characters in a cell and delets rest
So , i need a macro/function that keeps the first X characters in a cell ( the number is given ) and deletes the remaining characters Example In a cell i have the following text : *Mother and father* I want the macro to keep the first 8 characters . So , in that cell , the result should be : *Mother a* . When i mean charcaters , i take into consideration letter , space or number -- andrei ------------------------------------------------------------------------ andrei's Profile: 1056 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167722 Microsoft Office Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get rest of characters after last certain character? | Excel Programming | |||
Macro/function that keeps in a cell a given number of characters | Excel Programming | |||
Macro analyses Cell . If text found , delets entire row | Excel Programming | |||
macro which delets cell if the cell above has the same keyword | Excel Programming | |||
finding the first blank cell and then executing rest of macro | Excel Programming |