excel vba- extract text between 2 characters

by

You can use instr to locate a character within the string (returning the position of '(' for example). You can then use mid to extract a substing, using the positions of '(' and ')'.

Something like (from memory):

dim str as string
dim openPos as integer
dim closePos as integer
dim midBit as string

str = "NUMBER(8,3)"
openPos = instr (str, "(")
closePos = instr (str, ")")
midBit = mid (str, openPos+1, closePos - openPos - 1)

You may want to add error checking in case those characters don’t occur in the string.

More Related Contents:

  1. Count and Highlight keywords within phrases
  2. Loop through files in a folder using VBA?
  3. How to error handle 1004 Error with WorksheetFunction.VLookup?
  4. How can Excel VBA open file using default application
  5. How to compare two entire rows in a sheet
  6. Run same excel macro on multiple excel files
  7. how to detect whether VBA excel found something?
  8. VBA : save a file with UTF-8 without BOM
  9. Excel tab sheet names vs. Visual Basic sheet names
  10. Excel VBA looping through multiple worksheets
  11. When one should use Set [e.g for SpecialCells return value]?
  12. Saving a Excel File into .txt format without quotes
  13. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  14. Determine if cell contains data validation
  15. VBA – Range to jpg picture
  16. Fastest way to delete rows which cannot be grabbed with SpecialCells
  17. How to do late binding in VBA?
  18. How to break long string to multiple lines
  19. How to copy a chart from Excel to PowerPoint?
  20. vba paste not working
  21. mac excel vba loop : from list & then export as pdf
  22. Can Advanced Filter criteria be in the VBA rather than a range?
  23. How can I open this VBA workbook faster?
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel Useform: How to hide application but have icon in the taskbar
  26. Reading Web Pages using Excel VBA
  27. Excel VBA: auto click and open file from website
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment