none
How to UNCONCATENATE RRS feed

  • Question

  • Hello

    I have the following data in the same cell ( A1 )

    S:0
    M:0
    L:0
    XL:0
    XXL:0
    XXXL:5
    XXXXL:4

    i need it to be like :

    A1 : S:0

    A2 : M:0

    A3 : L:0

    A4 : XL:0

    A5 : XXL:0

    A6 : XXXL:0

    A7 : XXXXL:0

    Thanks





    i need it to be like :

    A1 : S:0

    A2 : M:0

    A3 : L:0

    A4 : XL:0

    A5 : XXL:0

    A6 : XXXL:0

    A7 : XXXXL:0

    Thanks




    i need it to be like :

    A1 : S:0

    A2 : M:0

    A3 : L:0

    A4 : XL:0

    A5 : XXL:0

    A6 : XXXL:0

    A7 : XXXXL:0

    Thanks

    Monday, February 1, 2016 10:43 AM

Answers

  • I am assuming that it is text wrapped in the cell and has line feeds within the cell. If so, my method requires the columns to the right of the cell containing the data to be empty (copy to another part of the workbook if necessary.)

    Select the cell and then select "Text to columns" in the Data ribbon.

    Select Delimited and use "Other" for the delimiter. To enter the character for the delimiter, click in the field and hold the Alt key down and then on the key pad at the right enter 0010 and finish. (Can't use the numbers along top of keyboard)

    The text should now be in separate cells across the worksheet. Copy the text and select the first cell for the destination and then Paste Special -> Transpose to get it down a single column.


    Regards, OssieMac

    Monday, February 1, 2016 11:05 AM