| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to removed the first three char and last char in XLS
I have one excel spreed sheet like 10001:F7110- first row, second row will
be like 10001:F7111-, third row will like 10001:F112-, how can I write macro remove 10 and last - in this excel sheet. Thanks. Lillian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| char() | Excel Discussion (Misc queries) | |||
| char 124 where is on my keyboard. | Excel Discussion (Misc queries) | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| CHAR(10) | Excel Worksheet Functions | |||
Threaded Mode
