Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trim function in a macro
Hi,
I would like to use a trim function to delete spaces before and after a text in an entire column, but so far I could only use it in a cell: Sub mac1() Dim testing As String testing = ActiveSheet.Range("A1") ActiveSheet.Range("B1") = Trim(testing) End Sub Thanks for any help, -- Domingos Junqueira |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRIM function | Excel Worksheet Functions | |||
trim function | Excel Worksheet Functions | |||
Need help with TRIM function | Excel Worksheet Functions | |||
Trim function | Excel Worksheet Functions | |||
Trim function in VBA | Excel Programming |