I use Regextract with Trim to cute phrases and variables out of the paragraph, the thing is that not all the time the paragraph has the same text but the values and variables are easy to get.
Now I want to have regextract
works with IF so if found XX in the paragraph then enters the value next to it using TRIM, if not use another parameter to search and insert its value.
Please check the example, it should be more clear:
https://docs.google.com/spreadsheets/d/1pUUTnbun3lhdOj1ejPQgbRMpXU8C6_HZ3ZWWDXc_3do/edit#gid=0
Aucun commentaire:
Enregistrer un commentaire