Concatenate column with leading space

Question

Dear All ,

I am stuck at one place in my workflow , please help me with the formula-

Input-

First NameMiddle NameLast NameJohn SmithCarlMaxHarley Dr.

if Middle Name first character is space we have to concatenate First Name and Middle Name and

if Last Name first character is space we have to concatenate  Middle Name and  Last Name and get the following output

Output -

First NameLast NameJohn SmithCarlMaxHarley Dr.

Many Thanks in advance

atcodedog05 · Answer

Hi @Ekta

Seems like there is only one similar generic way to solve this.

Here is my workflow

Input:

Output:

Workflow:

Formula : FirstName

IF Left([Middle Name], 1)=" " 
THEN [First Name]+[Middle Name]
ELSE [First Name]
ENDIF

Formula : LastName

IF Left([Last Name], 1)=" " 
THEN [Middle Name]+[Last Name]
ELSE [Last Name]
ENDIF

Hope this helps 🙂 give a like if you dont mind 😀👍

space.yxmd

Qiu · Answer

@Ekta 
I use one formula tool to get the output.

Please check if this is what you want, and if you do, kindly mark it as accepted. Thanks.

Ekta.yxmd

AngelosPachis · Answer

Hi @Ekta ,

I have mocked up a workflow that answers your question.

Let me know if that works for you. 🙂

Cheers,

Angelos

example.yxmd