Question Locked

Stripping formatting from text

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am entering data (cutting and pasting text)from Excel into a very clunky text editor (the interface for a database).

The text from Excel comes with a load of formatting (not just word wrapping but a whole lot of formatting from the tables that it was in before it was transferred to excell).

Is there a way to "bulk-remove" formatting from text in Excel worksheets (there are 770 cells that must be cut and pasted individually)

I know that pasting into notepad and the copying will remove formating but this adds too many steps in an already labour intensive process.

Cheers

2 replies

by thumbsup2

Save the spreadsheet as a comma separated text file, DOS type CSV, near the bottom of the "save as type". That strips all formatting and creates a text file with fields separated by commas. No frills.

Then, use notepad to open it up and copy from there to paste into your clunky editor.

This discussion is closed to new replies.