Delete Part of Cell?
 

Had a play around found it must have something to do with the " N" (th
leading space) If I take out the space it works, has VB not got a $ fo
a space like HTLM &nbs

--
Odysseu
-----------------------------------------------------------------------
Odysseus's Profile: http://www.excelforum.com/member.php...fo&userid=1456
View this thread: http://www.excelforum.com/showthread.php?threadid=27412

Delete Part of Cell?
 

Hi

have you tried my suggestion - any luck?

Cheers
JulieD

"Odysseus" wrote in message
...

Had a play around found it must have something to do with the " N" (the
leading space) If I take out the space it works, has VB not got a $ for
a space like HTLM &nbsp


--
Odysseus
------------------------------------------------------------------------
Odysseus's Profile:
http://www.excelforum.com/member.php...o&userid=14563
View this thread: http://www.excelforum.com/showthread...hreadid=274129

Delete Part of Cell?
 

the nbsp is the chr 160 I described. I described both the problem and a
solution.

--
Regards,
Tom Ogilvy

"Odysseus" wrote in message
...

Had a play around found it must have something to do with the " N" (the
leading space) If I take out the space it works, has VB not got a $ for
a space like HTLM &nbsp


--
Odysseus
------------------------------------------------------------------------
Odysseus's Profile:
http://www.excelforum.com/member.php...o&userid=14563
View this thread: http://www.excelforum.com/showthread...hreadid=274129