Member Avatar for zeroth
zeroth 171 Nearly a Posting Virtuoso

I hope somebody can help me convert some data from excel to a data base. Basically, I copied some data to an excel spreadsheet in this format:

John Smith
123 Stone Lane
New York, NY 12345
(212) 123-1234

Jane Smith
etc.

All in one column. I have tried the text to column under data tab but it doesn´t want to do anything. I´m just trying to get the four lines to convert to 6 columns. In the end, I want to delimit all of the entries of four lines each into a 6 field format I can export to ACT.

Win2Kpro and Act 2000

Any help or suggestions would be appreciated,
zeroth

  • 1 Contributor
  • 0 Replies
  • 82 Views
Catalana commented: would like to know that too +1
meksikatsi commented: interesting problem +1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.