ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can i remove commas from the alphanumeric list? (https://www.excelbanter.com/excel-programming/382267-how-can-i-remove-commas-alphanumeric-list.html)

Help me!

how can i remove commas from the alphanumeric list?
 


Doug Glancy

how can i remove commas from the alphanumeric list?
 
Simply reverse the steps that put them in there ;).

Seriously, though, you might want to give us more detail. Although some
people on this listgroup are borderline psychic, so maybe you'll get an
answer with just that.

Doug

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




NickHK

how can i remove commas from the alphanumeric list?
 
Range("A2").Value = Replace(Range("A1"), ",", "")

NickHK

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





All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com