Flip words in same cell.

[ctanxcel]

Hi
I want to flip words in same cell. Is there any formula.
Examples
Cell A1 "1232 india"
Cell A1 "India: 1232;"

Thanks in advanced

 

[hagia_sofia]

In 365 e.g.

=TEXTAFTER(A1," ")&": "&TEXTBEFORE(A1," ")&";"

 

[ctanxcel]

Wow it's working so nicely. Perfect..

Many thanks to you.

 

[ctanxcel]

Hello Good Morning.
Hope you are doing well
Could you help me with this. I want to flip words in same cell but now with abbreviations. Is there any formula that helps.
Examples
Cell A1 "1232 india 445 United States 468 United Kingdom 96 United Arab Emirates"
Into this format
Cell A1 "India: 1232; US: 445; UK: 468; UAE: 96;"

Thanks in advanced

 

[bebo021999]

Hello Good Morning.
Hope you are doing well
Could you help me with this. I want to flip words in same cell but now with abbreviations. Is there any formula that helps.
Examples
Cell A1 "1232 india 445 United States 468 United Kingdom 96 United Arab Emirates"
Into this format
Cell A1 "India: 1232; US: 445; UK: 468; UAE: 96;"

Thanks in advanced

UDF (User define formula) may help
Are you OK with VBA solution?

 

[hagia_sofia]

Hello, test this:

=LET(
a,A1,
b,TEXTSPLIT(TRIM(REDUCE(a,CHAR(VSTACK(SEQUENCE(15,,33),SEQUENCE(198,,58))),LAMBDA(a,b,SUBSTITUTE(a,b,""))))," ")&"; ",
c,TRIM(TEXTSPLIT(REDUCE(A1,SEQUENCE(10,,0),LAMBDA(a,b,SUBSTITUTE(a,b,"@"))),"@")),
d,FILTER(c,c<>""),
e,REDUCE(d,VSTACK(SEQUENCE(10,,0),CHAR(SEQUENCE(26,,97)),CHAR(32)),LAMBDA(a,b,SUBSTITUTE(a,b,""))),
CONCAT(TOCOL(VSTACK(IF(LEN(e)=1,d,e)&": ",b),,TRUE)))

 

[ctanxcel]

Hello, test this:

=LET(
a,A1,
b,TEXTSPLIT(TRIM(REDUCE(a,CHAR(VSTACK(SEQUENCE(15,,33),SEQUENCE(198,,58))),LAMBDA(a,b,SUBSTITUTE(a,b,""))))," ")&"; ",
c,TRIM(TEXTSPLIT(REDUCE(A1,SEQUENCE(10,,0),LAMBDA(a,b,SUBSTITUTE(a,b,"@"))),"@")),
d,FILTER(c,c<>""),
e,REDUCE(d,VSTACK(SEQUENCE(10,,0),CHAR(SEQUENCE(26,,97)),CHAR(32)),LAMBDA(a,b,SUBSTITUTE(a,b,""))),
CONCAT(TOCOL(VSTACK(IF(LEN(e)=1,d,e)&": ",b),,TRUE)))

Thank You..

 

[ctanxcel]

UDF (User define formula) may help
Are you OK with VBA solution?

Yes. Its ok