Forum Discussion
Deleted
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...
Haytham Amairah
Aug 12, 2017Silver Contributor
Hi Rayn,
Use this formula:
=PROPER(A2)&", "&UPPER(B2)