Formula help

[Jewells0905]

I am trying to generate one formula for cell C2, using the functions SPLIT and PROPER, to produce the first name with proper capitalization in cell C2, and properly capitalized last name into cell D2. I need to have D2 free from formulas
And then needing to combine CellsH2:K2, using functions PROPER and UPPER, to produce the full address in L2, with the states capitalized. I have tried several combinations and none are giving the results I'm after.


=PROPER(SPLIT(A3," ",FALSE,TRUE)) - this is what I'm currently working with in cell C2, which as you can see produces the first name into C2, but not the last name into D2. And of course this formula works to split the names into the cells but is not capitalizing the first/last name - =SPLIT(A2," ")

=PROPER(H2)&" "&PROPER(I2)&","&PROPER(J2)&","UPPER(K2) is giving me formula parse error in cell L2 currently, and the below is producing the desired address however, I can not figure out how to add in proper to get the state capitalized - =H3&" "&I3&", "&J3&", "&K3 (currently in H3)

Full Name				Gender	Phone		House Number	Street Name	City	State
james smith	Mr.James Smith	James		m	4176607092	(417) 660-7092	787	Madison	BIG SUMMIT	mo	#ERROR!
robert johnson	Mr.Robert Johnson	Robert		m	6037376794	(603) 737-6794	3728	Hilltop	BLUE SPRINGS	mo	3728 Hilltop, BLUE SPRINGS, mo
john williams	Mr.John Williams	John		m	8377096850	(837) 709-6850	8555	Aspen	BIG SUMMIT	mo	8555 Aspen, BIG SUMMIT, mo
linda brown	Ms.Linda Brown	Linda		f	9514182256	(951) 418-2256	9299	Sunrise	RAYTOWN	mo	9299 Sunrise, RAYTOWN, mo

 

[Kerryx]

=PROPER(H2)&" "&PROPER(I2)&","&PROPER(J2)&","&UPPER(K2)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Full Name				Gender	Phone		House Number	Street Name	City	State
2	james smith	Mr.James Smith	James		m	4.18E+09	(417) 660-7092	787	Madison	BIG SUMMIT	mo	787 Madison,Big Summit,MO
3	robert johnson	Mr.Robert Johnson	Robert		m	6.04E+09	(603) 737-6794	3728	Hilltop	BLUE SPRINGS	mo	3728 Hilltop,Blue Springs,MO
4	john williams	Mr.John Williams	John		m	8.38E+09	(837) 709-6850	8555	Aspen	BIG SUMMIT	mo	8555 Aspen,Big Summit,MO
5	linda brown	Ms.Linda Brown	Linda		f	9.51E+09	(951) 418-2256	9299	Sunrise	RAYTOWN	mo	9299 Sunrise,Raytown,MO
Sheet1

Cell Formulas
Range	Formula
L2:L5	L2	=PROPER(H2)&" "&PROPER(I2)&","&PROPER(J2)&","&UPPER(K2)

 

[FormR]

=PROPER(SPLIT(A3," ",FALSE,TRUE))

That looks like a google sheets formula - if that is the case, 1. you should probably mention such facts, and 2. you could try : =SPLIT(PROPER(A1)," ",FALSE,TRUE)

 

[Jewells0905]

these both worked thank you so much!

 

[Kerryx]

to be fair you had the hard work done just forgot the & before UPPER at the end

 

[Jewells0905]

to be fair you had the hard work done just forgot the & before UPPER at the end

Thank you! These formulas kick my butt sometimes, so I'm so appreciative of all of yalls help