+ Reply to Thread
Results 1 to 3 of 3

Insert maunal line break in formula

Hybrid View

  1. #1
    0-0 Wai Wai ^-^
    Guest

    Insert maunal line break in formula


    Hi
    I have a formula which combines texts from several sources.
    Eg:
    ="I am a "&A30&". You are a "&A31&".
    However we don't "&A32&", nor "&A33&".
    Except that, we do "&A34&"."

    However the whole statement will appear in 1 line.
    I would like to break it into 3 lines in that cell.
    How to do?


    --
    Additional information:
    - I'm using Office XP
    - I'm using Windows XP




  2. #2
    0-0 Wai Wai ^-^
    Guest

    Re: Insert maunal line break in formula

    Note:
    I have moved my question to "microsoft.public.excel.worksheet.functions"



  3. #3
    David McRitchie
    Guest

    Re: Insert maunal line break in formula

    and it would have been better to wait. One hour is not a long
    time to wait. Anyway Char(10) as in the reply that you got in
    the other newsgroup by Roger Govier. .
    http://google.com/groups?threadm=432...nology4u.co.uk

    Basically you have the same people reading and responding in
    several Excel newsgroups. Other factors are involved such as
    time of day which newsgroup people read first.

    But is was good of you to warn us that you posted elsewhere.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "0-0 Wai Wai ^-^" <x@x.com> wrote in message news:e5dXP1FtFHA.284@TK2MSFTNGP14.phx.gbl...
    > Note:
    > I have moved my question to "microsoft.public.excel.worksheet.functions"
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1