How to read double quoted strings

[ImranBhatti]

Hello
This macro found in the same forum extracts the double quoted strings in a long string and copies them vertically.

Please Login or Register  to view this content.

How can I get
1) Count of double quoted strings
2) Have them in one row separated by a space
3) May we create another array that contains only the double quoted strings (so that some other operations can be applied on them)?

Hope it makes sense.

Best Regards
Imran Bhatti

[Marc L]

Hi !

No need a loop …

To count use UBound function (to see in VBA inner help).

For « one row separated by a space » use Join function.

[TMS]

1 and 2:

Please Login or Register  to view this content.

[TMS]

For 3:

Please Login or Register  to view this content.

[TMS]

Formula version to get result in one cell:

Please Login or Register  to view this content.

[ImranBhatti]

2 is ok
1 needs to be in one row separated by a space
like
"a" "b" "c"
I used row wrongly I think..it must say in one cell

[ImranBhatti]

Formula version to get result in one cell:

Please Login or Register  to view this content.

Although I needed a VBA solution but the formula is not doing as expected.

[TMS]

Post a sample workbook with some typical data and expected results.