Thread: Extract alphabet from string.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Choy Bill Choy is offline
external usenet poster
  
Posts: 3
Default Extract alphabet from string.
Hi all,

Are there any suggestion to extract the first few alphabet
from a string? For example, "RC125", I want to scan this
string from the first character and extract "RC" to the
other cell. Please suggest a method to recognize between A-
Z and 0-9. Thanks.

Bill
Reply With QuoteReply With Quote