Extract a string contained between two quotation marks, Excel 2010
Solved
phenetas
Posted messages
1190
Status
Member
-
michel_m Posted messages 18903 Registration date Status Contributor Last intervention -
michel_m Posted messages 18903 Registration date Status Contributor Last intervention -
Hello,
I have a list of Excel cells containing text strings. These strings are structured as follows:
number,"text"
example:
1059,"test@test.fr"
I’d like to automate a script that would extract the text contained between the quotation marks.
In the example, the script would place test@test.fr in an adjacent cell (without the quotes).
Anyone to the rescue?
Configuration: Windows / Firefox 43.0
--
A vaincre sans péril on triomphe sans gloire.
I have a list of Excel cells containing text strings. These strings are structured as follows:
number,"text"
example:
1059,"test@test.fr"
I’d like to automate a script that would extract the text contained between the quotation marks.
In the example, the script would place test@test.fr in an adjacent cell (without the quotes).
Anyone to the rescue?
Configuration: Windows / Firefox 43.0
--
A vaincre sans péril on triomphe sans gloire.
