Add a space in Formula

[jhosmer002]

I have a pretty easy question, hopefully. This formula works to combine First Name and Last Name from two fields into one. The Output is FnameLname and I would like a space between to be Fname Lname. How do I add the space? Thanks! 

IF IsNull([Contact Full Name]) THEN [CEO First Name]+[CEO Last Name] ELSE [Contact Full Name] ENDIF

[JordyMicheal · Accepted solution]

Hi JHosmer!!

IF IsNull([Contact Full Name]) THEN [CEO First Name]+" "+[CEO Last Name] ELSE [Contact Full Name] ENDIF

Just a + " " + in between the lines you want to space.

Quote of a space 🙂

Hope that helps

[jhosmer002]

Thank you! I appreciate it! 

[LarsDellen]

Hm,

this is actually exactly what I tried, but in my case it was the result of a formula on phone numbers, where I wanted to add a blank space after the country code of a phone number.

The formula result being: +49123456789 should have resulted in +49 123456789

I used this formula:

[Country Code2] + " " + right(length([Phone corrected]-length([Country Code2]))

Country Code2= +49

phone corrected: +49123456789

The error is:

Error: Formula (93): Parse Error at char(157): Invalid type in operator ==. (Expression #3)

[JordyMicheal]

Hi @LarsDellen,

Don't know if you are still working on this but I would stand to guess your numbers are stored in integers.

Can't do "String" functions on "Numbers".

Grab a select too and convert it to a string and it should work.

Let me know if not!

[LarsDellen]

HI @JordyMicheal,

the field containing the phone number is in the format of V-WString as that oune seemed to be the right one (I need to have the plus symbol in there).

But adding a blank space in the formula ....+ " " +... results in errors. I've tried different type values, but this always seems to cause an error.

Any other ideas on how to integrate a blank space if not " "? 

[LarsDellen]

Hi @JordyMicheal,

the field containing the phone number is in the format of V-WString as that oune seemed to be the right one (I need to have the plus symbol in there).

But adding a blank space in the formula ....+ " " +... results in errors. I've tried different type values, but this always seems to cause an error.

Any other ideas on how to integrate a blank space if not " "? 

[LarsDellen]

....I found the solution...

it wasn't the blank space part of the formula, but a brackets closed wrongfully placed...

left([Country Phone Code], length([Country Phone Code])) + " " + right([Mobile corrected], length([Mobile corrected])-length([Country Phone Code]))