Forum Discussion
Anonymous
Aug 12, 2017Combining columns together while adding new information
My problem is I want to combine two columns together that have city and state but i also need to add a comma and a space in front of the state this is for like 6000 plus cells, i would like to be ab...
Wyn Hopkins
Aug 12, 2017MVP
Hi Ryan
=PROPER(A1)&", "&UPPER(B1)