How do I add another cell to this formula please?

[MsCynic]

I was provided with this formula by a kind user by the name of jtakw:
=IF(ISNUMBER(RIGHT(F2,4)+0),RIGHT(F2,4)+0,"")

It separates postcodes in the same cells as city names into their own cells. Some of my records' postcodes also fall within columns E or G. How can I add these so they are included along with Column F?

Thanks in advance for advice.

 

[rlv01]

As long as only one cell has postcodes this will work

=IF(ISNUMBER(RIGHT(E2,4)+0),RIGHT(E2,4)+0,IF(ISNUMBER(RIGHT(F2,4)+0),RIGHT(F2,4)+0,IF(ISNUMBER(RIGHT(G2,4)+0),RIGHT(G2,4)+0,"")))

But keep in mind that once it finds a post code , it stops looking. So think about the order of precedence you want. In the formula above, it's Col E,F,G

 

[MsCynic]

Thank you so much. Yes, each row will only have a postcode in one cell so this would be perfect. I've finished for the day now but will give this a run tomorrow. Thanks again.

 

[jtakw]

Hi MsCynic,

Didn't know you needed more columns checked, you never posted any follow up to your other thread.
Base on you original sample, you can do this:

Book1
	E	F	G	H	I
2	#### Papamoa Beach Road	Papamoa 3118			3118
3	Papamoa Village Park	###### Parton Road	Papamoa 3118		3118
4	Bayswater Village	###### Maranui Street	Mount Maunganui 3116		3116
Sheet7

Cell Formulas
Range	Formula
I2	=IFERROR(RIGHT(E2,4)+0,IFERROR(RIGHT(F2,4)+0,IFERROR(RIGHT(G2,4)+0,"")))

I2 formula copied down.

 

[MsCynic]

Thanks I thought I had posted a follow up question but when I went back to check it was not there. I wasn't sure if you were still around which is why I created a new thread - sorry for any confusion.

 

[jtakw]

You're welcome, no problem at all, and Yes, I'm around, hopefully for a long time.