|
|
#1
05-03-2017, 04:43 PM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Why when I paste text into word, blank space appears after a paragraph & I can't delete it?
|
AWD | Word | 3 | 10-16-2018 01:10 PM |
| how to get control/option-delete to only delete the word and not the preceding space | microsofthelp | Word | 0 | 11-20-2016 04:34 AM |
|
Delete Space
|
mariadanmark | Excel | 2 | 05-17-2012 02:53 AM |
|
how to delete table without losing space
|
tomcruiser | Word | 3 | 11-28-2011 03:24 PM |
| How to delete first 6 Digits and one Space from a CELL? | Learner7 | Excel | 3 | 08-10-2010 04:06 AM |
Mac OS X 
Office 2016
Threaded Mode