Home > IT Answers > Microsoft Windows > VBA – selecting middle portion of a string
McNitro
255 pts.
 VBA – selecting middle portion of a string
Excel 2003, Microsoft Excel 2003, String manipulation, VBA, Visual Basic for Applications
I'm having trouble pulling the middle portion out of a dynamic string. Ex: Orginal String 1 = John Doe, Age 35 (asd) Original String 2 = Tom Thompson, Age 100 (jkl) I need the code to produce... New String 1 = 35 New String 2 = 100 I've tried to research this, but am new to VBA and a lot of what I'm seeing doesn't make sense to me...VBA for Dummies please :)

Software/Hardware used:
ASKED: March 30, 2009  10:14 PM
UPDATED: March 31, 2009  2:10 PM
RELATED QUESTIONS
Answer Wiki:
Look for SUBSTRING and PATINDEX (I think VBA has both of those functions).
Last Wiki Answer Submitted:  March 31, 2009  3:55 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If you have some code that is not working, you might want to post it. You will get more specific help this way.

carlosdl
 63,535 pts.