Try using TRIM to remove extraneous spaces
Eg, in B1, copied down: =TRIM(A1)
Then if required, copy col B and overwrite col A with a paste special as
values. Then delete col B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"scubadiver" wrote:

I have some records which have blank cells that contain spaces. How can I
delete these spaces without deleting spaces in other cells which contain
information.

Does this make sense?

thanks