Combining Two Short Phrase Cells

Topic Labels: Formulas
840 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! I have a form configured for my clients to fill out that asks in two cells for first and last names. In the table view is it possible either through a function or formula to have a cell that combines the names together to easily sort and identify my client list?

Thank you.

2 Replies 2

Hi Brendan, I think this does what you’re looking for?

{First Name} & " " & {Last Name}

Screenshot 2022-09-09 at 2.19.46 PM

That’s what I needed. Thank you!