I'm trying to concatenate 3 different cells into a single cell that has each of 3 origianl cells' contents on it's own line.
For Example:
Given the below:
a2 a3 a4
John Doe 123 A Rd City,ST,Zip
I would like to have:
a1
John Doe
123 A Rd
City,ST,Zip...
PLEASE HELP!!
I'm looking for a way to do a phone book that lists a family's last name, followed by the first name of each member of the family.
I see it in my mind this way:
ADAMS John, Sue, Bill 123-456-7890
CARNEGIE Andrew, Julie, Mabel 123-222-0000
SMITH Heather...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.