Hi everyone. I’m trying to create a list workflow in which I extract certain words in a cell, and put them into another column. For example, if I have a group of sentences in a cell like this:

“The man in the city was out at dusk. He was in search of some food. The hotel closes soon, so he needs to hurry. The password to get into the hotel is PW: X3YH9T.”

I want to be able to extract just the “X3YH9T” and put it in another column that stores just the passwords. The “PW:…… ”format will be the same for all cells in that column, but they won’t necessarily be in the same place. I’ll leave it blank if there is no password given.

How would I go about doing something like this in SharePoint or SharePoint Designer? I wasn’t able to find any information online. Also keep in mind that I’m not allowed to have any plugins.

Thanks!