SOLVED
Cut Before / Cut After
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bakaidora
8 - Asteroid
01-18-2023
03:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Community,
I have an Excel sheet where I have a column with the Notes. This is a bulk text and I need to cut the NT user information out of this text.
I cannot say from which characters I need this information because it is different, the only thing I can say that the needed information is between two phrases.
e.g. "Q: NT-ID of affected user? A:ABC2BP Q: Client-ID / Computer name of affected user?"
And from this I only need ABC2BP. The phrases before and after ABC2BP are not needed for me, I would like to cut them.
Is there any easy solution which I can use to cut a words before and after the needed data?
Thanks in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
01-18-2023
03:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sarreddy
9 - Comet
01-18-2023
06:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
