Thread: How to delete all text after second space?
View Single Post
 
Old 05-03-2017, 04:43 PM
LCLARK LCLARK is offline Mac OS X Office 2016
Novice
  
Join Date: May 2017
Posts: 1
LCLARK is on a distinguished road
Default How to delete all text after second space?
I have this string of text:

MULLER PL (BEPM 100%) NEW CONDO LOT 16

I need to get rid of everything except MULLER PL. I have a large data set of these and they are all different lengths. For example, I also have: SHEFFIELD DR HAMPTON PARK (BEPM 100%) 6 PLEX" and I just need SHEFFIELD DR.

Help anyone?
Reply With Quote