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


--
kush2
-----------------------------------------------------------------------
kush28's Profile: http://www.excelforum.com/member.php...fo&userid=3103
View this thread: http://www.excelforum.com/showthread.php?threadid=51560