This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My solution using Regex formula
Please see my solution
Thought my solution was pretty lean until I opened up the posted solution and it was one tool! LOL
Started to do this with a ReplaceFirst expression but couldn't get the data types to line up for some reason. Ended up going with a more straight-forward solution.
Here's my solution:
Have a nice day!