Forum Discussion
CONCATENATE - copy cell values ?
I'm going to take the easy way here and point you to this page https://exceljet.net/excel-functions/excel-text-function where you'll find the answer to your question. When concatenating fields that are in fact numbers, you need to convert them to text, and there's a definite syntax for that. That page will introduce you to the correct syntax for each of those numeric fields.
I'm going to take the easy way here and point you to this page https://exceljet.net/excel-functions/excel-text-function where you'll find the answer to your question. When concatenating fields that are in fact numbers, you need to convert them to text, and there's a definite syntax for that. That page will introduce you to the correct syntax for each of those numeric fields.
- Thanks! I stumbled across a similar page a short while ago and realized that I didn't have my text "inserts" within the concatenate formula formatted quite right. I've got it working now, as wanted. Thank you for your time!! 🙂
