LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Info From Within A Text String nospaminlich Excel Worksheet Functions 4 January 31st 07 10:31 PM
Extracting info from web pages \\sh Excel Discussion (Misc queries) 0 November 1st 06 05:39 PM
Extracting info to new tables Dazed & Confused Excel Discussion (Misc queries) 1 September 19th 06 09:32 AM
Extracting info from a database J David Southwick Excel Programming 3 December 29th 03 10:19 PM
extracting info the best way shiepowk Excel Programming 1 November 5th 03 11:26 AM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"