How to break up a text string?

[gunkie]

I've used CONCATENATE for a long time. Now I need to grab certain sections of strings between sets of delimeters. I was hoping to find a nice simple command to do this but may need to create a macro.

Is it macro or some text function that I'm overlooking?

Thanks!

[VBA Noob]

Hi,

You can use a formula but a macro might be better if you do it often.

Can you post an example of your data and what the delimiter is ??

VBA Noob

[gunkie]

I just built a macro almost exactly from the Walkenbach text for extracting the field I needed and here it is for anyone who needs a similar tool:

'This Excel custom macro has been developed by SG Systems [www.sgsystems.com]
'No warranty or guarantee, implicit or explicit, is provided

Option Explicit


Public Function SGSYS_STRINGSPLIT(TXT_STRING, FIELD_NUMBER, DELIMITER) As String

Application.MacroOptions Macro:="SGSYS_STRINGSPLIT", Category:=14
Application.MacroOptions _
Macro:="SGSYS_STRINGSPLIT", _
Description:="STRINGSPLIT macro returns element from FIELD_NUMBER"

'varible declarations

Dim FINAL As Variant

'constant setup

FINAL = 0

'function area

FINAL = Split(TXT_STRING, DELIMITER)

SGSYS_STRINGSPLIT = FINAL(FIELD_NUMBER - 1)

End Function