Joining text fields

Need to join 2 text fields for 1: Address 2: Suburb into a field “Display Name”. So the formula is say
A7+A8. How can I insert a space between the two fields. What I’m getting is, AddressSuburd & I need to display Address(space) Suburb.
Any help would be much appreciated.


You could put space in formula, like this: A7+" "+A8

Many thanks works like a charm

1 Like