| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete left 8 characters in many cells
I'd like to ask if someone could provide a macro that would do th
following. I have several rows in one column. Looks like: 2000001_JSJSLSLS.tif I'd like to just be able to run through the entire column (approx 630 rows) and delete the 8 Left characters while leaving the remainin characters in the cell. Result like: JSJSLSLS.tif Any help appreciated. Thanks -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get characters on left of specified character in Excel | Excel Discussion (Misc queries) | |||
| Auto-ID and Delete/left shift cells when a cell contains text? | Excel Discussion (Misc queries) | |||
| auto delete characters in cell left of @ sign | Setting up and Configuration of Excel | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
| Left three text characters | Excel Programming | |||
Threaded Mode
