Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
take off the first two letters
Howdy folks,
I am looking for a way to take off the first two letters off of a list of excel records. There are an unknown about of excel records AE there could be 2 or 15000 records. Thanks for your help - good night and good luck, Will the Texan -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
take off the first two letters
somethinglikethis:-
Sub ShortenByTwo() Range("A1").select Do Until IsEmpty(ActiveCell) ActiveCell.Value = (mid(Activecell.value,3,len(activecell.value)-2) Activecell.offset(1,0).select Loop Range("A1").select End Sub 'somethinglikeant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
changing capslock letters into normal letters | Excel Discussion (Misc queries) | |||
how to change small letters to capital letters | Excel Discussion (Misc queries) | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) |