Please help me on below :
1. I have customer-wise Addresses. Address in each row and in one cell per customer.I want to Separating Pin-code (Zip-code) from Address in another cell.
Problem is Pin-code is not only present at the end of the address but also come in-between.
Pincode can be missing - For this case empty cell is the desired output.
There is also cases where inbetween pin-code there is space . Example :- 400 256 , Desired output in another cell will be 400256.
I am attaching the Excel where the sample data is there
Bookmarks