Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncate
Hell
Im trying to pices together code from here that will truncate the text to the left of and including "/" This is what I have so far but it isnt working. Sub Truncat Dim rng As Rang Dim c As Rang Set rng = Selectio For Each c In rn c.Value = Left(ActiveCell.Value, InStr(1, ActiveCell.Value, "/") - 1 Nex End Su All help is greatly appreciated Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Truncate | Excel Discussion (Misc queries) | |||
truncate chart | Charts and Charting in Excel | |||
How do you truncate 2.22 to just 0.22? | Excel Worksheet Functions | |||
How do I truncate something like this? | Excel Discussion (Misc queries) | |||
truncate | Excel Worksheet Functions |