- Messages
- 152
- Reaction score
- 0
- Points
- 26
Symbianize Forum
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
true power of MS excel. update: PowerBI
- Thread starter kirby21
- Start date
- Replies 2,271
- Views 192,527
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
Mga paps need ko po ng help sakit na tlga ng mata ko.. formula for hahatiin ung fullname
sample : Lastname,First Name Middle Name
output : Nash,Nash Nash Nash
Mga paps need ko po ng help sakit na tlga ng mata ko.. formula for hahatiin ung fullname
sample : Lastname,First Name Middle Name
output : Nash,Nash Nash Nash
- Messages
- 778
- Reaction score
- 95
- Points
- 28
- Thread Starter
- #1,145
Re: MS excel we give solutions. formula, codes and tutorials.
di ko magets boss. wag ka gumamit ng madaming nash. iba ibahin mo tapos iparehas mo dun sa sample mo.
di ko magets boss. wag ka gumamit ng madaming nash. iba ibahin mo tapos iparehas mo dun sa sample mo.
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
Nash, Kirby21 ackidcat Clief = LName, FName FName MName
Nash, Kirby21 ackidcat Clief = LName, FName FName MName
- Messages
- 77
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
@nash
as per my own understanding, yung fullname nasa isang column lang? then gusto mo ihiwalay ng columns?
di na kailangan ng formula.... Gamitin mo lang ung Text to Column na function ng Excel...
i hope i got it right... ^_^
@nash
as per my own understanding, yung fullname nasa isang column lang? then gusto mo ihiwalay ng columns?
di na kailangan ng formula.... Gamitin mo lang ung Text to Column na function ng Excel...
i hope i got it right... ^_^
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
pde po bang makahinge ng sample by using the text to column nagamit ko sia kaso d ka mapag laruan hehehe kpag ang fname nya eh dalawa sample mark anthony un tapos next column ko 1 lng fname nya mark lng kya d masyado ko magamit ung text to column minsan may jr sometng or ung middle name or last name dalawa kaya hrap hehehe
pde po bang makahinge ng sample by using the text to column nagamit ko sia kaso d ka mapag laruan hehehe kpag ang fname nya eh dalawa sample mark anthony un tapos next column ko 1 lng fname nya mark lng kya d masyado ko magamit ung text to column minsan may jr sometng or ung middle name or last name dalawa kaya hrap hehehe
- Messages
- 789
- Reaction score
- 18
- Points
- 128
Re: MS excel we give solutions. formula, codes and tutorials.
Tama ka, yun yung limitation nia. Pero Kung hindi naman ganun kadami, manual mo nlng pag samahin.
See Demo:
Without using Text to Column
Tama ka, yun yung limitation nia. Pero Kung hindi naman ganun kadami, manual mo nlng pag samahin.
See Demo:
Without using Text to Column
| A | B | C | |
| 1 | Full Name | Last Name | First Name |
| 2 | Smith, John James | Smith | John James |
| 3 | Formula | =LEFT(A2,FIND(",",A2)-1) | =SUBSTITUTE(A2,B2&", ","") |
Last edited:
- Messages
- 161
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
Ppa- Subscribe Mga Bossing !
for sharing TS
Ppa- Subscribe Mga Bossing !
for sharing TS
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
ty paps.. pero kpag kasama po ang middle name na may prefix ba tawag dun ung Jr etc po
ty paps.. pero kpag kasama po ang middle name na may prefix ba tawag dun ung Jr etc po
- Messages
- 789
- Reaction score
- 18
- Points
- 128
Re: MS excel we give solutions. formula, codes and tutorials.
Pano bang formatting ng name na may Jr, Sr? Sa last name din sya diba mkksma? Suffix yata tawag dun (Prefix sa unahan)
Pano bang formatting ng name na may Jr, Sr? Sa last name din sya diba mkksma? Suffix yata tawag dun (Prefix sa unahan)
Last edited:
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
eto po sample ng name
format: Lname,Fname Mname
napapasingit na lng po kpag may suffix po sia tulad nung mabutas may III, ung rebano nmn may space ung middle po
Mercado, Denise Natalie Fajardo
Mabutas, Vincent Peter Ramon III Santos
Rebano, Justin George Del Rosario
eto po sample ng name
format: Lname,Fname Mname
napapasingit na lng po kpag may suffix po sia tulad nung mabutas may III, ung rebano nmn may space ung middle po
Mercado, Denise Natalie Fajardo
Mabutas, Vincent Peter Ramon III Santos
Rebano, Justin George Del Rosario
- Messages
- 789
- Reaction score
- 18
- Points
- 128
Re: MS excel we give solutions. formula, codes and tutorials.
Gamiting mo yung formula, wag yung Text to Column, gumagana naman.
Gamiting mo yung formula, wag yung Text to Column, gumagana naman.
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
ginamit ko po ngaun pero ung sa
eto po ung nangyari
sample
Mercado, Denise Natalie Fajardo
=LEFT(A2,FIND(",",A2)-1) = "Mercado"
=SUBSTITUTE(A2,B2&", ","") = "Denise Natalie Fajardo"
yan po ung nangyayari sa data ko po ung middle name nasasama po sa fname Y_Y
ginamit ko po ngaun pero ung sa
eto po ung nangyari
sample
Mercado, Denise Natalie Fajardo
=LEFT(A2,FIND(",",A2)-1) = "Mercado"
=SUBSTITUTE(A2,B2&", ","") = "Denise Natalie Fajardo"
yan po ung nangyayari sa data ko po ung middle name nasasama po sa fname Y_Y
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
opo
b2= First name
c2= Middle Name
d2= Last Name with suffix if mern po un po
opo
b2= First name
c2= Middle Name
d2= Last Name with suffix if mern po un po
- Messages
- 152
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
un nga po ung poblema ko hehehehe
un nga po ung poblema ko hehehehe
- Messages
- 50
- Reaction score
- 0
- Points
- 26
Re: MS excel we give solutions. formula, codes and tutorials.
mga master! patulong meron akong workbook na may worksheet per year 2008 - 2015. per worksheet merong data from column A to F
A = Customer
B = Date
C = Receipt No.
D = Date Paid
E = Amount
meron akong 100k rows per worksheet.
hirap ako open per workbook kasi malaki yung file. gusto ko sana iextract yun specific customer at datas from B to E sa lahat ng worksheet sa ibang workbook. possible ba?
mga master! patulong meron akong workbook na may worksheet per year 2008 - 2015. per worksheet merong data from column A to F
A = Customer
B = Date
C = Receipt No.
D = Date Paid
E = Amount
meron akong 100k rows per worksheet.
hirap ako open per workbook kasi malaki yung file. gusto ko sana iextract yun specific customer at datas from B to E sa lahat ng worksheet sa ibang workbook. possible ba?
