Solution for large data set

[Pappeh]

Hey everyone,

I am working with a spreadsheet of a huge amount of data. I generated it from a .txt file by pasting the text into Word, generating a spreadsheet using space as the field separator, and pasting it into Excel. However, some fields were separated by multiple spaces, so a lot of my data is offset by one or two cells. I had been going through deleting the empty cells and shifting cells accordingly, but there are about 12,000 rows of cells. Is there a smarter way to go about this? Is there a way to have excel do this for me?

 

[pplstuff]

In your text file (or word) use the find/replace feature and replace the double-space with a single-space. Repeat until the program cannot find any more double-spaces. Then import into Excel.

 

[tonyyy]

Nice approach, pplstuff. Wish I'd thought of that.

And to Pappeh, if you really want an Excel solution, you might try the following macro...

Sub DeleteBlankCells()
  On Error Resume Next
  ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).Delete shift:=xlToLeft
End Sub

Cheers,

tonyyy