In this article, I'll show you how to concatenate two column Texts.
- Full Name = FirstName & LastName
- Full - Name = CONCATENATE(FirstName, "-",LastName)
- =TEXT([soldOn],"mm-dd,yyyy")
Create new List Name: Concatenating with following columns:
|
Column (click to edit)
|
Type
|
Required
|
|
SKU
|
Single line of text
|
|
|
dept
|
Choice
|
|
|
soldOn
|
Date and Time
|
|
|
unitsSold
|
Number
|
|
|
product
|
Single line of text
|
|
|
fullProdName
|
Calculated (calculation based on other columns)
|
= [SKU] & " - " & [product]
|
|
report
|
Calculated (calculation based on other columns)
|
= CONCATENATE([unitsSold], " - ",[SKU]," 's "," from the ", [dept], " department were sold on " , TEXT([soldOn], "mmm-dd,yyyy"))
|
|
Output:
