Hello all,
I am very familiar with the "text to columns" feature in excel. I want my data split into columns on what appears to be a return carriage. Delimited wont work do to inconsistent spacing. Here is an example of what the cell data looks like.
<tbody>
</tbody>
so the above is all in one cell: the spaces as I said before between these data points appears to be 2 return carriages, as far as I can tell. This spacing is consistent across all my data which is about 200 rows. By the way I didn't even know you could put carriage returns into a cell? and I need a way to split them
I am very familiar with the "text to columns" feature in excel. I want my data split into columns on what appears to be a return carriage. Delimited wont work do to inconsistent spacing. Here is an example of what the cell data looks like.
<tbody> </tbody> |
<tbody>
</tbody>
so the above is all in one cell: the spaces as I said before between these data points appears to be 2 return carriages, as far as I can tell. This spacing is consistent across all my data which is about 200 rows. By the way I didn't even know you could put carriage returns into a cell? and I need a way to split them