View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bretter99 Bretter99 is offline
external usenet poster
 
Posts: 16
Default How can i add a line break into a formula in excel 2000?

For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want it to
put the result into a single excel cell like this:
I
LIKE
BEEF
BURGERS

But i cant see how to manually insert a line break into my statement as in
something like:
=concatenate(a1,<line break,a2,<line break,a3,<line break,a4,<line break,)
Any suggestions would be appreciated, thanks :P