Quickly process text using split() spreadsheet function in google docs
Google docs spreadsheet app is going mainstream with each passing day. Recently they have introduced split() formula to divide text in to multiple cells using a user specified delimiter.
The syntax for this function is
=split(text value, delimeter), for eg.
=split("pointy haired dilbert", " ") would result in 3 individual cells with “pointy”, “haired” and “dilbert” as values. Learn more.
This is a very good replacement for excel import text functionality using which you can paste large text files in to excel sheet.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Photographic Fridays #10 – At the Niagara Falls||Date with my sheet – 10 tips on using date / time in excel »|