Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Concatenation Question

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Covina, Ca
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi-

    Is it possible to concatenate two text strings with a line break in between (like hitting alt-enter)? Please advise.

    Thanks,

    Gil

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes it is, via formula or VBA.

    If formula, try
    =A1&CHAR(10)&A2
    with the formula cell formatted for wrapped text.

    If VBA, try something like
    ActiveCell = [A1] & Chr(10) & [A2]

    Any help?

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Covina, Ca
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, Tom!

    -Gil

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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