What's Formula Separate Text In 3 Space

[Joko Purnomo]

What's Formula Separate Text In 3 Space Front, For More Text or Sentence

Example :
1. Showroom Maju Jaya Auto Palembang Sukabangun
2. Showroom Andi Naya Rivera Medan Markisa

Please Help me, not one by one formula

Tks

 

[Joko Purnomo]

If you have 365, use the formula in B1. Otherwise, try the formula in B2, and please update your profile to show what version of Excel you're using so we don't have to guess.

text before.xlsx
	A	B
1	Showroom Maju Jaya Auto Palembang Sukabangun	Showroom Maju Jaya Auto
2	Showroom Andi Naya Rivera Medan Markisa	Showroom Andi Naya Rivera
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXTBEFORE(A1," ",4)
B2	B2	=LEFT(A2,FIND("|",SUBSTITUTE(A2," ","|",4))-1)

Excel 2016 version

 

[kevin9999]

Excel 2016 version

In that case, the formula in B2.

 

[Joko Purnomo]

In that case, the formula in B2.

Thank bro, let try for helping

 

[Peter_SSs]

Excel 2016 version

Please add that to your profile as requested in post #2 so users always know your version (making it as easy as possible for people to help you )

Also @SunnyAlv and @Joko Purnomo
In future, as noted on the main forum page, please post in English only in this forum.