| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
crop away the letters
For the following, I need to crop away the letters with a macro, excel
97 VWXY1234567Z CropIt = Right(Liscence, 8) 1234567Z How do I crop away the "Z" leaving only 1234567 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| crop AutoCAD object | Excel Discussion (Misc queries) | |||
| crop spreadsheet | New Users to Excel | |||
| Is there a way to crop text in an Excel cell? | Excel Discussion (Misc queries) | |||
| Any function for Crop/Cut Text | Excel Worksheet Functions | |||
| I want to truncate/crop 3854502.2 into 545 in Excel. How do I do. | Excel Worksheet Functions | |||
Threaded Mode
