microsoft.public.excel.misc
[Top] [All Lists]

split prefix and suffix

Subject: split prefix and suffix
From: RayNDM83
Date: Wed, 22 Jul 2009 09:49:01 -0700
Newsgroups: microsoft.public.excel.misc
C22K001
C15K015A
FA28K005A

Hi, 
Could someone help me to split the cell and drop the prefixes C and FA as 
well as the suffix A? What will be left will read 22K-001, 15K-015 or 28K-005.
Thanks for the help.
Ray

<Prev in Thread] Current Thread [Next in Thread>