Need formula for Unique Value

[amkumar]

hello,

I have some data in 4 cells and i need their unique value in a single cell in below format.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]CITY[/TD]
[TD]ZIP[/TD]
[TD]AREA[/TD]
[TD]CODE[/TD]
[TD]UNIC NAME[/TD]
[/TR]
[TR]
[TD]MUMBAI[/TD]
[TD]853024[/TD]
[TD]2019[/TD]
[TD]MBHA[/TD]
[TD]MU_19_BH_24[/TD]
[/TR]
</tbody>[/TABLE]


Thanks

 

[Michael M]

Try using

=LEFT(A2,2)&"_"&RIGHT(C2,2)&"_"&MID(D2,2,2)&"_"&RIGHT(B2,2)

 

[amkumar]

this working fine.

Thanks