Double quotes x2 meaning

[Kevineamon]

Hi guys

I'm fixing a number of excel sheets here atm. Unfortunately the original designer isn't here anymore. I keep stumbling across, what I think might be code, from previous versions of excel.

Eg.
=CONCATENATE(MID(C4,FIND(" ",C4)+1,1),"_",$N$8,$N$9,IF(G4 = "","",$N$10),IF(G4 = "","","_"),E4,IF(E4 = "","","_"),G4)

See this "",""

What exactly does that mean? I can't search for it on google properly. Thanks

 

[Fluff]

This
IF(G4 = "","",$N$10)
Is saying if G4 is blank, then leave cell blank, otherwise insert the value from N10

 

[Kevineamon]

Excellent thank you Fluff. Must be the older way to do it I'm guessing.

 

[Fluff]

I wouldn't call it an "older way", you'll see plenty of examples of that type of formula on here