Mcoc Garrot7
Reputation: 1
google sheets, search and replace for next colum
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 should be
Upvotes: -1
Views: 37
Answers (1)
DN Oomsoo
Reputation: 34
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 :
Upvotes: 0
Related Questions
- Suppress #N/A returned by Google Sheets vlookup
- ISO-8601 String to Date in Google Sheets cell
- Google Sheets multiple search and replace from a list
- How can I use RegEx to find and replace over multiple columns in Google Sheets using App Script?
- ArrayFormula and "AND" Formula in Google Sheets
- Google Sheets - Combining COUNTBACKGROUNDCOLOR and COUNTIF formulas
- Batch image search with Google Sheets
- Automatic Search and Replace in Google Sheets with a script
- Google Sheets Find and Replace script
- Google spreadsheet search for part ,replace and delete