Join two Fields with formula and content control

[margusveer]

Hello!

How I can join two columns what I need Join with IF - example:

Area	City	Location
Haljala	Haljala	Haljala
Hiiumaa	Palade	Hiiumaa | Palade
Muhu	Muhu	Muhu
Kullamaa	Kullamaa	Kullamaa
Saaremaa	Aste	Saaremaa | Aste

If the City and Area name are same then formula shows that name only one time
If City and Area names are different then formula shows two different names With space or some symbol between them

[Sho · Accepted solution]

Hello, @margusveer ,

Try this formula

{Area} & IF({Area} = {City},""," | " & {City})

[pressGO_design]

IF(Area=City, Area, CONCATENATE(Area, ” | “, City)

You can replace the “ | “ bit with another symbol.