Thread: Forced return??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WTG
 
Posts: n/a
Default Forced return??

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