Formula cell maodifies text

[ARiios]

Hi! 

I'm having trouble with a formula where it brings back text and adds " " when it is done. 

Here is the layout:
Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}

Column 2: Linked to another table, displays {Client} names (Example: John)

Column 3: {Total Volume} quantity (Example: 10)

What I want to get from this formula is = John - 10

What I'm getting from this formula is = “John“ - 10

Is this because I am linking to another table? It does not happen with every value from the {Client} column! 

[AlliAlosa · Accepted solution]

The quotes signify that you either have a commas or a line break in your primary field on the table housing your clients. If you open up the record for “John”, I would guess there’s a carriage return after his name.

[Dan_Montoya]

have you considered using concatenate()?

does it give a different result?