Microsoft Office Forums - View Single Post - How to delete all text after second space?

Thread: How to delete all text after second space?

View Single Post

Old

05-04-2017, 09:38 PM

jolivanes

jolivanes is offline

jolivanes uses Windows 10

Windows 10 jolivanes uses Office 2013

jolivanes uses Office 2013

Office 2013

Advanced Beginner

Join Date: Sep 2011

Posts: 91

jolivanes will become famous soon enough

Default

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)

Reply With Quote