| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete 1st character if string is longer than 6 characters
Hello,
I have a list of values in column C (275,372 cells) and would like to know if there is a way to look at each cell and delete the 1st character if the string is longer than 6 characters. Below is what the before sample would look like. 009075 009130 0009767 010471 010489 011640 013373 013824 017424 019038 020634 020642 020663 0020711 020723 So the above list will look like this after: 009075 009130 009767 010471 010489 011640 013373 013824 017424 019038 020634 020642 020663 020711 020723 Thanks you for any help you can provide, DIDS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How replace a character in a string of characters? | Excel Programming | |||
| Extracting a character from a string of characters | Excel Discussion (Misc queries) | |||
| Remove all characters following the first character in a string | Excel Discussion (Misc queries) | |||
| String Not Longer Than 255 Characters in VBA? | Excel Programming | |||
| Delete characters from a string | Excel Programming | |||
Threaded Mode
