PC Review


Reply
Thread Tools Rate Thread

how can i remove commas from the alphanumeric list?

 
 
=?Utf-8?B?aGVscCBtZSE=?=
Guest
Posts: n/a
 
      30th Jan 2007

 
Reply With Quote
 
 
 
 
Doug Glancy
Guest
Posts: n/a
 
      30th Jan 2007
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 me!@discussions.microsoft.com> wrote in message
news:71B346FA-556E-447F-BEA1-(E-Mail Removed)...
>



 
Reply With Quote
 
NickHK
Guest
Posts: n/a
 
      31st Jan 2007
Range("A2").Value = Replace(Range("A1"), ",", "")

NickHK

"help me!" <help me!@discussions.microsoft.com> wrote in message
news:71B346FA-556E-447F-BEA1-(E-Mail Removed)...
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Text From AlphaNumeric Bam Microsoft Excel Worksheet Functions 11 12th May 2010 05:33 AM
Remove Numbers from Alphanumeric String =?Utf-8?B?RGF2ZQ==?= Microsoft Excel Misc 19 29th Oct 2007 09:01 PM
how to remove number from alphanumeric cell =?Utf-8?B?SWduZXNod2FyYSByZWRkeQ==?= Microsoft Excel Worksheet Functions 3 12th Apr 2007 01:12 AM
Remove commas =?Utf-8?B?WFA=?= Microsoft Access Queries 1 25th Jan 2007 12:31 AM
Remove commas =?Utf-8?B?Z2FyZXRoaG9wMjI=?= Microsoft Access 1 20th Jan 2006 06:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:45 AM.