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
 
Back
Top