Hi Brett
looking again it seemed that it was more than just a space - as the normal
method of getting rid of spaces didn't fix the problems - i had to run a
macro over the column - the code below is from
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
--------
Sub TrimALL()
'David McRitchie 2000-07-03 mod 2000-08-16 join.htm
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim cell As Range
'Also Treat CHR 0160, as a space (CHR 032)
Selection.Replace What:=Chr(160), Replacement:=Chr(32), _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
'Trim in Excel removes extra internal spaces, VBA does not
On Error Resume Next 'in case no text cells in selection
For Each cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
cell.Value = Application.Trim(cell.Value)
Next cell
On Error GoTo 0
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
------
to use it, open your workbook, right mouse click on a sheet tab and choose
view code - you'll see your workbooks'name on the left hand side of the
screen, if you can't choose view / project explorerclick on the workbook's
name and choose insert / module then copy & paste the above code into the
white hand side of the screen, then use ALT & F11 to switch back to your
workbooknow select the column to fix up and choose tools / macro / macros -
trim all - runlet us know how you goCheersJulieD