I have an Excel WB with Sheet1 that has a table called “Leads” where the first column in labeled “Address”
I have inserted additional columns labeled “City”, “State”, and “Zip” to the right of “Address” which are all empty.
In the “Address” column, I have a list of addresses that looking like this
123 SUMMER ST, MINNEAPOLIS, MN 55499
I want to split that into the “City”, “State”, and “Zip” by comma, comma, and space.
I’ve looked at many posts and haven’t seen a solution for this within UiPath Studio.
Your help is greatly appreciated.