CONCATENATE("PN: “,TEXT([PN]),” ","Q: “,[Q],” “,“GRC:”,[GRC],” ","LOC:
“,[LOCATION],” ","B: “,LEFT([BUYER],6),” ","P: “,LEFT([PLANNER],6),”
","T: “,LEFT([TECH],6),” ","DR: “,[DR],” ","HN: ",[HN]) I’m trying to
get the TEXT in the columns such as [PN]...