I have a column containing an address in each row. I need something in VBA that will delete everything after the second space in each address, including the second space. The closest thing I could find was this formula:
=LEFT(A1,Find(" ",A1)-1)
This deletes everything after the first space in a cell but I need something to include in a VBA routine. Any suggestions are greatly appreciated.
=LEFT(A1,Find(" ",A1)-1)
This deletes everything after the first space in a cell but I need something to include in a VBA routine. Any suggestions are greatly appreciated.