Forum Discussion

null null's avatar
null null
Copper Contributor
Oct 06, 2017

Having trouble splitting data in 1 cell

I have multiple lines of data that is in 1 cell that I would like to 'Text to Columns'.  Every time that I try to separate it the lower half of the data disappears.  This is what it looks like:

 

ALLZ WELL PHARMACY LLC 
  821 E Oakland Park Blvd;Oakland Park;FL;33334
excel
Excel on Mac

5 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 06, 2017

    Hi,

     

    First replace in your text line breaks on semicolons - open Find & Replace; stay on Find what: bar and press Ctrl+j. After that semicolon in Replace with.

     

    Now Text to Columns with semicolon delimeter

    • null null's avatar
      null null
      Copper Contributor
      Oct 06, 2017

      Hi Sergi,

      When I am on the Find Bar and I hit Ctrl+j the computer just beeps.

      Ron

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Oct 06, 2017

        Just recognized you may do that in one step - in Text to Columns select two delimeterts - semicolon and Other. Into the box near Other enter Ctrl+j

         

         

        But all that is for Windows. Try to check if Ctrl+j works on Mac as well

Resources