Hi
I have been trying to find a formula that would extract a number from a string of text.
The cell in the Excel spreadsheet is formatted as below and I would just like to extract the number between the :'s.
user:12345678:supportuser
system:87654321:systemuser
Hoping someone can help
Bookmarks