Forum Discussion

wskinnermctcsp's avatar
wskinnermctcsp
Copper Contributor
Aug 19, 2022

SharePoint Calculated Column Combine First Middle Last Name without Additional Spaces

Hello, I am currently working on making columns that will be used in a document set. When a new folder is created they will have to input the names (First, Middle, Last, Suffix). The document set col...
Lists
SharePoint Online
  • kalpeshvaghela's avatar
    kalpeshvaghela
    Aug 20, 2022

    wskinnermctcsp 

     

    You should try below formula which will not add additional space if any field don't have value:

     

    =CONCATENATE(TRIM(FIRST_NAME),IF(ISBLANK(TRIM(MIDDLE_NAME)),""," "),TRIM(MIDDLE_NAME),IF(ISBLANK(TRIM(LAST_NAME)),""," "),TRIM(LAST_NAME),IF(ISBLANK(TRIM(NAME_SUFF)),""," "),TRIM(NAME_SUFF))

     

    For more function about calculation field in SharePoint visit Calculated Field Formulas

     

    Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

kalpeshvaghela's avatar
kalpeshvaghela
Steel Contributor
Aug 20, 2022

wskinnermctcsp 

 

You should try below formula which will not add additional space if any field don't have value:

 

=CONCATENATE(TRIM(FIRST_NAME),IF(ISBLANK(TRIM(MIDDLE_NAME)),""," "),TRIM(MIDDLE_NAME),IF(ISBLANK(TRIM(LAST_NAME)),""," "),TRIM(LAST_NAME),IF(ISBLANK(TRIM(NAME_SUFF)),""," "),TRIM(NAME_SUFF))

 

For more function about calculation field in SharePoint visit Calculated Field Formulas

 

Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

  • wskinnermctcsp's avatar
    wskinnermctcsp
    Copper Contributor
    Aug 25, 2022

    Thanks kalpeshvaghela your formula works just as well. I'm marking your response as best because it is a little easier to read logically than mine.

Resources