Concatenate Text In Cell With Blank Line In Between

  • I need to catinate some text information with a blank line between.


    This goes on a label for exporting.


    For example:


    Item number: 123 (this comes from A1)
    Description: Display Kit (this comes from B1)
    Made In: USA (this comes from C1)



    I have catainated this: "Item Number" & "A1" ....then I need a carriage return??
    to start the next line .


    " Item Number: " & "A1" & char(10)?? &"Description: " &"b1" & Char(10) &"Made In " & "C1"



    Desired result:

    Item number:123
    Description: Display Kit
    Made In: USA


    Thanks

  • Re: Catenate Text In Cell With Blank Line In Between


    Looks to me like you're there. Just format the cell where the formula appears to wrap text.

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]

  • Re: Catenate Text In Cell With Blank Line In Between


    Try this formula ="Item Number: " & A1&CHAR(10) &"Description: " &B1 & CHAR(10) &"Made In " &C1


    and make sure to check the Wrap Text box on the Alignment tab of Format-Cells.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!