View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DannyDont
 
Posts: n/a
Default Excel 'Special' Character

I am attempting to combine three columns into one. This is not a problem.
However, I would like to combine the info into two 'lines' in the result
field. On the keyboard I would use 'Alt' + 'Enter'. Is there a 'special'
code for this 'Alt' + 'Enter' that I can include in a formula?

Result Column1 Column2 Column3
----------------------------------------------------
Foltz Foltz Dan Sue
Dan & Sue
----------------------------------------------------
Result is only 1 cell.

I can handle the remainder of the formula but need to 'hard' code for the
'Alt' + 'Shift'. LLike in Word, you can do a find for a paragraph marker by
using '^p' or a tab using '^t'.

Thanks for any help you might provide.
Dan