Need help in combining three columns, each with three cells with different text - that share the same part number in a different column. Want to combine (in this example), the three cells per col... dcd2020 I realize that asking "Why?" may sound impertinent. I have learned through many...
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... Hi Ryan =PROPER(A1)&", "&UPPER(B1)...
how i add space while combining text from 2 cells using concatenate I am trying to combine text from 2 cells using concatenate. However I am unable to include a space between the 2 text or give a comma Formulas & Functions Need Help kudo count Reply View Full Discussion (2 Replie...
Thank you for your reply. The cells are as above. A1 is Brown, James Arthur B1 is R2.D2 C1 is @pcsb.org Columns A & B are as imported from our grading software. I'm trying to add the pcsb.org to complete the email address asR2.D2@pcsb.orgI'm thinking the c...