Thread: can i write a macro to truncate alpha-numeric data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
raypayette raypayette is offline
external usenet poster
  
Posts: 1
Default can i write a macro to truncate alpha-numeric data?

This is the key code:
a = Replace(ActiveCell.Value, "s", "")
the rest is up to you!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570980

Reply With QuoteReply With Quote