How to split a large text without space into blocks of 2, 3, 4, 5, …. letters

[F6exb]

How to split a large text without space into blocks of 2, 3, 4, 5, …. letters with a spreadsheet.
• Copy the text in A1.
• In A10 type 1.
• In A11 type 6 (if you need blocks of 5).
• Select A10 and A11 and copy vertically down to NbChar/5.
• In B10 write: “=STXT($A$1;A10;2)”.
• Copy vertically.
• C10: “=B10”.
• C11: “=CONCATENER(C10;” “;B11)”.
• Select C11 and extend down.
• At the bottom, in the last cell, you have the text divided in blocks.

[F6exb]

Sorry, there is an error:
Replace
In B10 write: “=STXT($A$1;A10;2)” with
In B10 write: “=STXT($A$1;A10;5)”.

[Mattyrat2027]

@F6exb When you say write: “=STXT($A$1;A10;5)”. do you have to write just =STXT($A$1;A10;5) or the “” as well? I am no good with spreadsheets, sorry! Likewise with “=CONCATENER(C10;” “;B11)” and “B10”.

Thanks
P.s. I am using Numbers, which is the Mac Excel, but I don’t know it if it makes a difference.

[F6exb]

Excel vs Numbers: https://spreadsheeto.com/numbers-vs-excel/#versus
You can also use LibreOffice which is free: https://www.libreoffice.org/download/download/?type=mac-x86_64&version=7.0.4&lang=fr

[F6exb]

@Mattyrat2027
I mean just =STXT($A$1;A10;5) and =CONCATENER(C10;” “;B11).
In english, STXT is MID and CONCATENER is CONCATENATE

📊 Liste de fonctions Excel utiles (Français – Anglais)

[Author]

Posts