Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default how can i remove commas from the alphanumeric list?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 770
Default 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
...



  #3   Report Post  
Posted to microsoft.public.excel.programming
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
...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Text From AlphaNumeric Bam Excel Worksheet Functions 11 May 12th 10 05:33 AM
Remove Invereted Commas Rumy Excel Discussion (Misc queries) 3 December 31st 09 04:56 PM
how to remove number from alphanumeric cell Igneshwara reddy[_2_] Excel Worksheet Functions 3 April 12th 07 01:12 AM
How to remove commas from a downloaded .dat file? arvind Excel Worksheet Functions 3 September 5th 06 01:09 PM
Remove commas from Windows buffer Rasmus[_2_] Excel Programming 2 January 7th 04 10:25 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"