how to get all the values closer to the left..(with no blank cells in between) ?

[pooja2010]

Hi,

I have an excel file, lets say

VI V2 V3 V4 V5 V6
S1 87 "B" "B" 78 89
S2 "B" 89 90 33 "B"
S3 "B" "B" "B" "B" 23
S4 78 "B" "B" "B"90

"B" indicates a blank cell here

I need to bring all values closer, without having any blank cells in between (irrespective of the columns). So I need a file as follows:

VI V2 V3 V4 V5 V6
S1 87 78 89
S2 89 90 33
S3 23
S4 78 90

Can anyone tell me how do I achieve this ?

 

[Jonmo1]

Press CTRL+A to select all the data
Press CTRL+G
Select Special
Select Blanks
Click Ok
Right click any highlighted Cell - Delete
Shift Left
OK


Hope that helps.

 

[pooja2010]

Thanks a lot. It works..