I want to build a database.
I've extracted some text from my group's phone directory. It comes
out in one column with name on the first line, address on the second
line, city, state, zip on the third line and phone on the fourth line.
I'm trying to figure out a way to automate getting the info broken up
into columns.
I want to create a formula that will allow me to highlight 4 or 5 lines
and then break those lines into 4 or 5 columns.
My list has hundeds of names so cut and paste is a bit tedious.
Is there such a way to do this?