August 12th 06, 07:59 AM
posted to microsoft.public.excel.misc
|
|
external usenet poster
|
|
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
|
|
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
|