Tuesday, 16 March 2021
  0 Replies
  2.9K Visits
0
Votes
Undo
I am trying to extract an alpha numeric string from a cell that contains a class description.  The string is https://vimeo.com/12345678 where the numbers vary in each link.  I have tried using Text to Column and adding a character to the string, but this doesn't separate the string enough.  I also thought I could do a Find Replace using wildcards, but it replaces the numbers with the astrick.  Is there a way to extract this from the cell easily?  I have 263 descriptions, so blocking and copying is untenable.  I do have Kutools if that has a function.  Here is a sample of the the data that I am trying to extract the information from.  Any help would be appreciated. <p class="paragraph-node normal-paragraph-node" data-subtype="normal" style="text-align:left">Adobe InDesign and Adobe Acrobat are the dynamic duos of interactive PDF forms creation. While you can create great-looking, fillable forms in InDesign, integrating Adobe Acrobat into your workflow will lead to a better experience for the user and yourself. Going beyond its paper predecessor, Adobe Acrobat Forms (AcroForms) will help you collect the right information, the first time and save a few trees along the way.</p><p class="paragraph-node normal-paragraph-node" data-subtype="normal" style="text-align:left"><br/></p><p class="paragraph-node normal-paragraph-node" data-subtype="normal" style="text-align:left">https://vimeo.com/424365559</p><p class="paragraph-node normal-paragraph-node" data-subtype="normal" style="text-align:left"><br/></p><p class="paragraph-node normal-paragraph-node" data-subtype="normal" style="text-align:left">Q&A:</p><p class="paragraph-node normal-paragraph-node" data-subtype="normal" style="text-align:left">https://vimeo.com/433492255</p>
There are no replies made for this post yet.