Adding a space between two names

[DataIsFun]

Hello Alteryx Community,

I have a situation where I have a fictitious list of names such as the below:

Name

Dean

Emmarose

James

Sarahjane

What I need to do in the case of say Emmarose and SarahJane is just put a space between the names so it would look like Emma rose for example.

It is probably not to difficult but I just can't figure out a way to do it thanks to the community as always for any help

[OzlemSigbeku]

It would be hard to do this without a specific rule to signify the second name e.g. a capitalized letter for the surname (EmmaRose rather than Emmarose). In that case you can use a regex tool to parse our the first and second name and a formula tool to bring the two parsed fields together with a and added ' '. I can upload a workflow if useful.

[DataIsFun]

Hi @OzlemSigbeku That would be helpful to have a look and see how it would look

[OzlemSigbeku]

Let me know if this doesn't solve your issue.