SimonHughes
Well-known Member
- Joined
- Sep 16, 2009
- Messages
- 507
- Office Version
- 365
- Platform
- Windows
Hello, I need to extract the first three characters from a string where the characters are one of the following: UV2, UV3, UV4, UV5. The characters are always to the left of the column. I could probably use a LEFT, IF/OR formula but would appreciate any help.
I am using Excel 2010 on Win 7
I am using Excel 2010 on Win 7