| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim and Mid with VBA
Hi,
I need help to include this formula: =MID(TRIM(A7),12,20) into a existing VBA procedure. I need to run the procedure in Column C for all the names in Column B Thank you, -- Regards, Jeff |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trim and Mid with VBA
To get rid of extra spaces within the text
Sub trimit() x = Mid(Application.Trim(Range("a7")), 3, 6) Range("f4") = x End Sub -- Don Guillett SalesAid Software "Jeff" wrote in message ... Hi, I need help to include this formula: =MID(TRIM(A7),12,20) into a existing VBA procedure. I need to run the procedure in Column C for all the names in Column B Thank you, -- Regards, Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
