Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

normal Extract multiple lines from cell

More
1 week 4 days ago #1767 by Excelfans
Replied by Excelfans on topic Extract multiple lines from cell
Hello,
Please try to create a sample workbook and try it again.
If the problem persists with the sample workbook, please get in touch with us via support@extendoffice.com.

Please try to contact us via sales@extendoffice.com or support@extendoffice.com.
Please try to be more specific about your issue in the email, and you will get the solution quickly.

Please Log in or Create an account to join the conversation.

  • tttuuu
  • tttuuu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 week 5 days ago #1764 by tttuuu
Replied by tttuuu on topic Extract multiple lines from cell
Does anyone know? Should be possible right?

Please Log in or Create an account to join the conversation.

  • tttuuu
  • tttuuu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 weeks 5 days ago #1745 by tttuuu
Extract multiple lines from cell was created by tttuuu
I know I can use Quickly extract certain text from cells in Excel tutorial for extracting a certain part from a cell, but I am facing the following:

I have an Excel sheet with a lot of the following information per single cell:

CN=SEC Cursus Part - schrijven,OU=Afdelingsschijf,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=SEC Cursus User - beheren,OU=Afdelingsschijf,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=CAG - SAS SMS token,OU=AAC Policies,OU=Kork Tetcher - Advanced Access Control,OU=Application and Groups,OU=Beheer,OU=_Organisatie,DC=chned,DC=local^CN=SEC Mpwn User - beheren,OU=Afdelingsschijf,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=ENV Desktop Office 32-bit,OU=Environment,OU=Groepen,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=APP GEEN kwarant,OU=Psoch Quarant,OU=Application,OU=Groepen,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=ENV chned,OU=Environment,OU=Groepen,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=Poppy - Users,OU=AAC Policies,OU=Knetter Lijp - Advanced Access Control,OU=Application and Groups,OU=Beheer,OU=_Organisatie,DC=chned,DC=local^CN=\# chned - Alle medewerkers,OU=Distributielijsten,OU=chned,OU=_Organisatie,DC=chned,DC=local

I need to have the following extracted per cell >> every line that begins with "SEC" and ends with "beheren". As you can see this is the case for 2 lines in this example (sometimes it will lead up to 10 times or maybe more).

When I use this tutorial I will get the following output:
SEC Cursus Part - schrijven,OU=Afdelingsschijf,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=SEC Cursus User - beheren,OU=Afdelingsschijf,OU=chned,OU=_Organisatie,DC=chned,DC=local^CN=CAG - SAS SMS token,OU=AAC Policies,OU=Kork Tetcher - Advanced Access Control,OU=Application and Groups,OU=Beheer,OU=_Organisatie,DC=chned,DC=local^CN=SEC Mpwn User - beheren

But I would like to have the following 2 lines as an output:
- SEC Cursus User - beheren
- SEC Mpwn User - beheren

Who can help me with this one? Thanks!

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun