How to delete all text after second space?

LCLARK · #1 05-03-2017, 04:43 PM

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?

macropod · #2 05-03-2017, 07:07 PM

Is this to be done in the same cell (i.e. everything after the 2nd space is forever deleted) or in a separate cell (thus allowing the source cell to retain the full data)?

jolivanes · #3 05-04-2017, 09:38 PM

If you want a formula.
Your data should be in A1 on down and the formulas in B1 on down.

Code:

=LEFT(A1,SEARCH(" ",A1,SEARCH(" ",A1)+1)-1)

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