View Single Post
  #2   Report Post  
Old August 12th 06, 07:59 AM posted to microsoft.public.excel.misc
raypayette raypayette is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
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's Profile:
View this thread: