[Jebbit]

Trying to figure out how to import information from multiple cells into one on another sheet.

Bob | bobby | 111 bobby ln | macville |TN | 99999

To one cell

Bob bobby
111 bobby ln
Macville, tn 99999

In a format to print labels? Any help or direction would be great.

[JBeaucaire]

Not sure what you mean by import. But concatenating values from multiple cells into one is pretty simple.

    A     B         C              D      E     F
1 bob | bobby | 111 bobby ln | macville |TN | 99999

The first concatenation formula would be:
=A1&" "&B1

Next line:
=C1

Last line:
=D1&", "&E1&" "&F1

[Jebbit]

I believe that is what I am looking for. I am downloading sheets from a Mary Kay web site, it saves it in the back ground as excel and access files. I want to format a section that I can cut and paste into a section and have the other excel page into readable/printable labels.

[JBeaucaire]

Well, concatenation actually allows you to format a SINGLE cell with all those strings and it will format them correctly for label-type printing.

=A1&" "&B1&CHAR(10)&C1&CHAR(10)&D1&", "&E1&" "&F1

As long as you format the cells to AUTO-WRAP, this will look perfect. See the attached example.