If you are not concerned about internal spaces, just use Find/Replace to
remove them.
--
Gary''s Student
gsnu200701


"Sandra via OfficeKB.com" wrote:

Ive received a spreadsheet that has the addresses in one cell, separated by
commas. Ive used Text to columns Delimited Comma to split these into
four different cells. The problem is that at the beginning of the three new
cells there is a space before the text. Is there any way to delete all these
spaces other than going into each cell and deleting?

Thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1