Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Tuesday, 16 March 2021
  0 Replies
  2.8K 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.