Exporting/Formatting External Data?

  • Thread starter Thread starter Arsenio Oloroso
  • Start date Start date
A

Arsenio Oloroso

Looking for some good tips on how to do this more efficiently. My main
problem is how to quickly format row labels with spaces.

In brief, here's how I do it, which, admittedly, involves drudgery.

For a table in, say, .pdf format, I copy the table into an MS Word
document. Then, doing a search-and-replace, I substitute semicolons for
the spaces in order to de-limit the data prior to exporting it into Excel.

Of course, this also inserts semicolons between the words in the row
labels, e.g., "Number;of;things."

I then manually delete the semicolons--and the spaces they occupy--in
the row labels prior to using Excel's import data utility to get it all
into the spreadsheet. After this, I go back into the row labels and
re-insert the spaces between the words.

While this all works, I can't believe I'm doing this in the most
efficient manner. Can anyone suggest an easier way?

Thanks.
 
Perhaps you could eliminate some steps.
How do you tell the difference between spaces in labels, and spaces
between fields?
 
Yeah, that's the point--I can't figure how differentiate between spaces
in the labels and spaces in the fields.
 
Back
Top