Add a space in Formula

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

Common Use Cases

Accepted answers

JordyMicheal

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

All comments

JordyMicheal

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)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703