How to delete all text after second space?

		Microsoft Office Forums > Microsoft Excel > Excel
How to delete all text after second space?

05-04-2017, 09:38 PM

jolivanes

Windows 10 How to delete all text after second space?

Office 2013

Advanced Beginner

Join Date: Sep 2011

Posts: 91

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 AM.