Multi Field Formula not Working on the First Column

I have a data like so:

Name1	Age	Name2	Name3
Jack, Jill	20	James, Lebron	Ian, Anthony

The following multi field formula successfully rearranges the names in column Name2 and Name3 to Lebron James and Anthony Ian, but it does not work on column Name1.

I made sure to select the column, and it is not creating any new column either.

Help

Accepted answers

acarter881

Hello, are there instances in which there are no spaces after the comma? See spoiler.

Spoiler

All comments

MilindG

Make sure you do not have the Age column (Numeric) column selected. It worked for me.

kathleenmonks

Hi @shaheer,

Given the example and expression you posted, it worked for each of the columns on my end. Can you post your workflow?

mceleavey

Hi @shaheer ,

this is working for me.

I've attached the workflow, can you try it out?

mceleavey solution.yxmd

acarter881

Hello, are there instances in which there are no spaces after the comma? See spoiler.

Spoiler

shaheer

The age column is not selected on my end. I have several columns that aren't selected either, other than the ones that I need.

shaheer

Yes!!! This solved it, thank you so much. The names in column Name1 do not have a space after the comma whereas every other column does.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703