🔒 Closed Excel Formula

[_gHe]

Good day mga boss,

heLp Lang,
meron kasi akong employees data extracted from system,
gusto ko sana i ayos kasi sobrang gulo.
baLe ganito siya
A1: Unit 1408 Richville Corporate Tower, Madrigal Business Park Muntilupa City, Corporate Tower, Madrigal BusinesUnit 1408
B1: Unit 1408 Richville Corporate Tower, Madrigal Business Park Muntilupa City

yung A1 is yung problem and
yung B1 is ung resuLt dapat.
madami kasi masyado, need taLaga formulated.

sana may maka heLp.
Thanks

 

[Dyzuke]

Idolo kung ang tinutukoy mo lang ay madelete yung last character or word after 2 comma

pwede po itong formula sayo

=Left(A1,FIND("#",SUBSTITUTE(A1,",","#",2))-1)

 

[fblaze]

pwede ganito

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

 

[_gHe]

Idolo kung ang tinutukoy mo lang ay madelete yung last character or word after 2 comma

pwede po itong formula sayo

=Left(A1,FIND("#",SUBSTITUTE(A1,",","#",2))-1)

View attachment 2494991

maraming saLamat po dito,.
Laking tuLong nito,
baLe, gawan ko na Lang ng way yung iba,..
mostLy kasi is waLang mga commas.
sobrang guLo,..
hehehe

pwede ganito

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

Maraming saLamat dito sir,

 

[Vil_n]

impressive, bakit di ko to naisip

 

[calar2015]

Alt d+e tapos concatenate ka nalng. Refering sa ilan characters batch sorting nalng mariming paraan.