Forum Discussion
Text to columns
We are migrating from one database to another. I have a customer spreadsheet with an address block which is all in 1 column but separated by line breaks that needs splitting into 6 columns. When you ...
Axle-Flipps_1 Could be solved with a combination of Sequence and index?
INDEX(B3:B20;SEQUENCE(COUNTA(B3:B20)/6;6))
See attached file for example.
/Geir