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)
As options you may use - PivotTable using the measure to concatenate texts . Sample is herehttps://www.mrexcel.com/excel-tips/pivot-table-with-text-in-values-area/, the only to use line feed (char(10)) instead of comma as delimeter - PowerQuery - query main table, reference on it ...
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 comma between the names and the period in between R2 and D2 of the email address could be a problem? I have not...
{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":true,"title":"Resources","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":...
I have 3 columns I'd like to combine so I can export them and create a contact group in Outlook. ="Brown, James Andrew" ="R2.D2" '@school.org I'd like to combine columns B and C to create a...