View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default how can i remove commas from the alphanumeric list?

Range("A2").Value = Replace(Range("A1"), ",", "")

NickHK

"help me!" <help wrote in message
...