| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete left 8 characters in many cells
Thanks Ron.
It could also be modified to work on a selection instead of column A: Sub RemoveLeftEightSelection() Selection.TextToColumns _ Destination:=Selection.Cells(1.1), _ DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 9), Array(8, 1)) End Sub Ron de Bruin wrote: I like that one Debra -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| 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
