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.

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


    You have the right Idea. You just need to format your cell to "Wrap Text"


    lenze

Participate now!

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