Batch removal of empty cells in Excel

MFG

Joined
Jun 3, 2005
Messages
4
Reaction score
0
Hi folks

I am importing data from the EPRIME (psych experimentation) software. These files log reaction times and responses, etc. The problem is that the clolumns contain some cells with no information and are blank, e.g.

Resp1.ACC ... repeated for 48 columns (variables)
<empty>
3
<empty>
<empty>
4
<empty>
0
<empty>
<empty>
<empty>
5
<empty>
0 ....etc, in 36 rows

How can I remove these empty cells, without having to do it manually?

Regards - MFG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top