google sheets, search and replace for next colum

Question

I have a list of things and want to get them in two seperate colums. Can I do that by using search and replace ? or How do I do this ? Here is an example

How it is

how it is now

How it should be

how it should be

you can select that column, go to Data > Split text to columns > Separator > Custom > : then press enter. — z..
– z.., Commented Mar 31, 2024 at 19:28

DN Oomsoo · Accepted Answer · 2024-04-01 01:24:40Z

0

Try the following formula:

=ArrayFormula(split(A1:A2,": "))

Or you can go to the menu, click on Data > Split Text to Columns > Separator: Custom > and enter :

edited Apr 1, 2024 at 1:24

answered Apr 1, 2024 at 1:24

DN Oomsoo

362 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

google sheets, search and replace for next colum

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related