JakkeJakobsen
Board Regular
- Joined
- Sep 10, 2014
- Messages
- 94
Hi! I can't seem to find a way to split cells in Excel using formulas (I need it to be dynamic, so I can't use the built-in splitter).
What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't find a working formula anywhere.
I usually work in Google Sheets, which has been way ahead of Excel for some years now, having stuff like =sort, which came to Excel last year or so, as well as =split, which splits by a delimiter, and it worked in my sheet. However, browser-based spreadsheets tend to get slow, mine is a professor in slow now, as I am using it to draw oil patterns for bowling lanes based on the input below. So I want an offline version that also works in Excel, as its a lot faster.
Sooo, any tips?
<tbody>
</tbody>
EDIT:
http://svolvarbowlingsenter.no/Patte...Norway2019.pdf
This is what I use this spreadsheet for, basically. This is done in Google Sheets, but I only lack this little split function from Google Sheets converted to Excel for it to work everywhere! :D
You can see the data I am looking to split in this PDF, top center, "Zone Oil Per Board Data". This was originally like the data in the table in my first post.
What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't find a working formula anywhere.
I usually work in Google Sheets, which has been way ahead of Excel for some years now, having stuff like =sort, which came to Excel last year or so, as well as =split, which splits by a delimiter, and it worked in my sheet. However, browser-based spreadsheets tend to get slow, mine is a professor in slow now, as I am using it to draw oil patterns for bowling lanes based on the input below. So I want an offline version that also works in Excel, as its a lot faster.
Sooo, any tips?
<tbody> </tbody> |
<tbody>
</tbody>
EDIT:
http://svolvarbowlingsenter.no/Patte...Norway2019.pdf
This is what I use this spreadsheet for, basically. This is done in Google Sheets, but I only lack this little split function from Google Sheets converted to Excel for it to work everywhere! :D
You can see the data I am looking to split in this PDF, top center, "Zone Oil Per Board Data". This was originally like the data in the table in my first post.
Last edited by a moderator: