Splitting The Column

[sathishkm]

Hi All,

I have address column and zip code. Here based on the Zip Code (Column B ) I need to split the address like before zip code in one column, zip code that matches in separate column and after zip code in separate column. Please find the attachment file.

[modytrane]

Formulas:

C2: =LEFT(A2,FIND(B2,A2)-1)
D2: =B2
E2: =RIGHT(A2,LEN(A2)-FIND(B2,A2)-LEN(B2)+1)