Exporting/Formatting External Data?

  • Thread starter Arsenio Oloroso
  • 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.
 
D

Debra Dalgleish

Perhaps you could eliminate some steps.
How do you tell the difference between spaces in labels, and spaces
between fields?
 
A

Arsenio Oloroso

Yeah, that's the point--I can't figure how differentiate between spaces
in the labels and spaces in the fields.
 
Top