View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Extra Spaces with copied data


The blank spaces may not really be "spaces". They may be HTML
non-breaking spaces.

To remove them:
EditReplace
Find What: [alt]+0160 <-Hold down the [Alt] key..press 0160...release
[Alt]
Replace with: (leave this blank)
Click [Replace All]

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=490089