Forum Discussion
excel_learner
Jul 08, 2022Brass Contributor
Using Left Function with If statement
I am using the Left function to get first two letters of a Postal Code, however in some of the postal codes the first two characters contains a number. How can I ignore the number in the postal codes...
- Jul 08, 2022
SergeiBaklan
Jul 08, 2022MVP
- excel_learnerJul 12, 2022Brass Contributor
Thank You, this works
- SergeiBaklanJul 12, 2022MVP
excel_learner , you are welcome