Separation B,C,V into different columns

[THEBookMan]

Have:
BOOK Chapter Verse in one column. (Genesis 13:15)

How to separate chapter into 2nd column and verse into 3rd column ?

[Wanderer]

@THEBookMan

Genesis 13:15

Use Text-to-columns and set space and : as separators for columns
https://help.libreoffice.org/latest/en-US/text/scalc/01/text2columns.html

A picture of the dialogue is shown in this thread (for , and / as separators):

Text to columns does not work with multiple select

Text to columns applies for a single range in one column, not multiple selection available. But you can do it, pasting as unformatted text with Paste special [Ctrl+Shift+V] Menu/Edit/Paste special: Data: M,0.455,0.365,0.095,0.514,0.2245,0.101,0.15,15 M,0.35,0.265,0.09,0.2255,0.0995,0.0485,0.07,7 F,0.53,0.42,0.135,0.677,0.2565,0.1415,0.21,9 M,0.44,0.365,0.125,0.516,0.2155,0.114,0.155,10 [image description]

[THEBookMan]

Perfect !

I didn’t want to do it to each of 1000 lines

Thanks

[THEBookMan]

PERFECT

Thanks,
⌡im