Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim all but the first 5 characters in cell
How would I write the trim to leave only the first five characters in a
column? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim all but the first 5 characters in cell
Dim rng as Range, cell as Range
With Activesheet set rng = Intersect(.usedRange,.columns(5)).Cells End With for each cell in rng cell = Left(cell.Text,5) Next -- Regards, Tom Ogilvy "Annette" wrote in message ... How would I write the trim to leave only the first five characters in a column? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim all but the first 5 characters in cell
that does the trick .. thanks!
"Tom Ogilvy" wrote in message ... Dim rng as Range, cell as Range With Activesheet set rng = Intersect(.usedRange,.columns(5)).Cells End With for each cell in rng cell = Left(cell.Text,5) Next -- Regards, Tom Ogilvy "Annette" wrote in message ... How would I write the trim to leave only the first five characters in a column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim characters | Excel Worksheet Functions | |||
Trim Characters Other Than An Empty Space At The End Of A Cell | Excel Worksheet Functions | |||
How do you trim characters? | Excel Worksheet Functions | |||
Trim the last two characters? | Excel Programming | |||
Trim characters | Excel Programming |