Use the split command

Demo'd from the immediate window:

? sStr
**Item "app04:/C/" for client "app04"
v = split(sStr,"""")
? v(0)
**Item
? v(1)
app04:/C/
? v(2)
for client
? v(3)
app04

--
Regards,
Tom Ogilvy


"indiana1138" wrote in message
oups.com...
Hi all,

I need to run a loop search where I find a cell in a particular column
that begins with the text, "**Item". I can do that. But when I find it,
there will be a text string of varying length inside that is bordered
by quotes, and I need to extract that string to a variable. The cell
contents will look something like this:

**Item "app04:/C/" for client "app04"

The two strings in quotes are what I need to extract. The structure of
these cells will always be the same, like:

**Item "something" for client "something"

Can anyone help? I've hit a a pothole in my brain. :)

Thanks,

Bob