Thread: Separate a String of #'s
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Coal Miner Coal Miner is offline
external usenet poster
  
Posts: 21
Default Separate a String of #'s
Perfect. Thank you.

"ViestaWu" wrote:

Please try mid(your_string, 10,3).

"Coal Miner" wrote:

I have a column of #'s which are all somewhat similar. They are
X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
I would like ONLY the 3rd string of #'s. Any easy way?
Reply With QuoteReply With Quote