eliminating leading space

Make sure the cells are not formatted as text. If it still doesn't work, post an example.

attached is tab-delimited .txt version of spreadsheet ... I must be missing some simple thing because it doesn't seem to work ...

if you figure out what the problem is, wonderful, because I have this situation with about 20 other spreadsheets I work with and have resorted to basically rekeying the info (which is annoying and very very time-consuming)

thanks for your help

it won't let me post the spreadsheet, will it ... I tried that the first time but it said it didn't recognize the file (so I looked at the list and didn't see .xls on the list)

You need to zip it, max size 100K.

OK, run this after you import:

Sub x()
    Dim cell As Excel.Range
    
    For Each cell In ActiveSheet.UsedRange
        If IsError(cell) Then
            cell.ClearContents
        Else
            cell.Value = WorksheetFunction.Clean(cell.Value)
        End If
    Next cell
End Sub

Never mind posting the workbook unless you still have problems.

shg: You are wonderful! Thank you so much. You have now saved me about 10 hours each week of messing with stats before I can actually analyze them.

Trevor