Concatenate column with leading space

[Ekta]

Dear All ,

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

Input-

First Name	Middle Name	Last Name
John	Smith	Carl
Max	Harley	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 Name	Last Name
John Smith	Carl
Max	Harley Dr.

Many Thanks in advance

[AngelosPachis]

Hi @Ekta ,

I have mocked up a workflow that answers your question. 

Let me know if that works for you. 🙂

Cheers,

Angelos

[Qiu]

@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.

[atcodedog05]

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 😀👍