View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Patrick is offline
external usenet poster
 
Posts: 160
Default Extracting info from a string using VBA plz

Hello everyone!!

Need to create a custum function in Excel that will allow me to extra
a series of numbers from a string.

The string will have a fix format, so this should facilitate the process.
The numbers im looking for are always going to be serounded by brakets.

Ex: test(234)test2

From this example and using the brakets as guidlines, what type of code would
be able to extract the '234' number.

Thx for your hlp,
Patrick