Is each part a separate VLOOKUP? If so you could use something like

=vlookup_formula_1&CHAR(10)&vlookup_formula_2&CHAR (10)&...



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"WTG" wrote in message
...
Hi Me again :)

I'm looking for help on a wrapped cell.

I have cell a1 on sheet1 that reads

14140, Al Cat, 456 notre dame ave, (456) 456 5613

I use Vlookup to bring it into cell B2 on sheet4. it's a wrapped cell
and I'd like it to show the following:

14140,
Al Cat,
456 notre dame ave,
(456) 456 561

But it doesn't :(


Is there a way to force a return between each group so it will do
this?

Thanks for the help

Wally