IF AND Remove Text

[Smyth_County]

I'm trying to write a formula to remove the "➟" if the preceeding field is empty.

Current Formula:

Origin& " ➟ " &{Destination}&" ➟ "&{Backhaul From}& " ➟ "&{Backhaul To\\Return}& " ➟ " &Origin &" - LANE #" & {LANE#} 

Here is the output of the above formula.  Formula above works great, (example 1 below) but if there is no data in {Backhaul From} and {Backhaul To\\Return} the result is example 2 with 2 extra arrows.  Example 3 is the desired results.

1) Walmart ➟ Kroger ➟ Target ➟ Walmart - Lane # 1

2) Walmart ➟ Kroger ➟ ➟ ➟ Walmart - Lane # 2

3) Walmart ➟ Kroger ➟ Walmart - Lane # 2

I've tried BLANK() IF AND with no luck.  Can this be accomplished?

[TheTimeSavingCo · Accepted solution]

Try using an IF for each field:

Origin & 
IF(
  Destination,
  " ➟ " & {Destination}
) &
IF(
  {Backhaul From},
  " ➟ " & {Backhaul From}
)

[pressGO_design · Accepted solution]

Origin& " ➟ " &{Destination}&
IF({Backhaul From}, " ➟ "&{Backhaul From})&
IF({Backhaul To\\Return}, " ➟ "&{Backhaul To\\Return})&
 " ➟ " &Origin &" - LANE #" & {LANE#} 

[Smyth_County]

Thanks this worked!  

[Smyth_County]

Thanks this worked!