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...
Thank you all so far!
The main problem I have is getting the first names to print on a report next to the family last name. I have the last name in a group header and the first names in the detail section. I want the first names to print next to the family last name. Columns don't work because...
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.