View Single Post
 
Old 05-02-2013, 10:02 AM
snunicycler snunicycler is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: May 2013
Posts: 1
snunicycler is on a distinguished road
Default can find and replace instances of the "enter" key?

this is my first post and I hope i'm posting in the correct spot.
Hi Everyone!

ok here's my problem: My Final exam is a comprehensive exam from all of the questions for our previous tests. The professors sent us all of these questions (in a word doc) as a study guide. i want to load them on my ipad as flash cards but the app i found needs a very specifically formatted spreadsheet (I'll get to that later). The questions are currently formatted this way:

Question 1 is a question about something
Answer a
Answer b
Answer c
Answer d


But I need to get rid of all the instances of the “enter” key and replace it with the “tab” key so that it formats it like this:

Question 1 is a question about something Answer a Answer b Answer c Answer d

I have done about 20 of them manually and it is taking forever and driving me insane, especially since I still have about 380 to go…. I tried using the “find and replace” option but even with the “special” button I have not found anything that will find instances of the “enter” key. Any ideas? I really do not want to spend the next several hours doing this manually.
Thanks!

(PS: It needs to be formatted that way so when i paste it into the spreadsheet, each question with the corresponding answers are on the same row, right now each answer is on a different row so the app has no idea what is going on).
Reply With Quote