On Wed, 22 Feb 2006 22:11:01 -0600, kush28
wrote:


Hi

is there a way to check if a cell has spaces in it ?

If there is then can we remove the spaces.

for eg.

Logan Central Plaza ... <--- how can i remove the spaces to make it

LoganCentralPlaza please

Any idea

Thanks
K

=SUBSTITUTE(A1," ","")


--ron