swap text left side of comma with text right side of comma

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,465

Office Version

1. 365

Platform

1. Windows

• Oct 5, 2014

• #2

Give this formula a try...

=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)-1)

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Oct 5, 2014

• #3

Try

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)

 

Upvote 0

I

IvoOvermars

New Member

Joined

Aug 6, 2010

Messages

12

• Oct 5, 2014

• #4

Hang on having this annoying dutch version with also translates the formulas :s. Figuring out what dutch formula to use

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Oct 5, 2014

• #5

Look heree http://www.mrexcel.com/forum/questions-other-languages/462498-worksheet-function-translations.html

and replace , with ;

 

Upvote 0

I

IvoOvermars

New Member

Joined

Aug 6, 2010

Messages

12

• Oct 5, 2014

• #6

Not sure why yet. But I get an error on the underlined part

RECHTS(A1,LENGTE(A1)-VIND(",",A1)-1)&" "&LINKS(A1,VIND(",",A1)-1)

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Oct 5, 2014

• #7

Probably should be

RECHTS(A1;LENGTE(A1)-VIND(",",A1)-1)&" "&LINKS(A1;VIND(",",A1)-1)

 

Upvote 0

I

IvoOvermars

New Member

Joined

Aug 6, 2010

Messages

12

• Oct 5, 2014

• #8

Thank you got it to work. I had to replace the one word formula FIND with VIND.ALLES. Wich translated means Find.ALL

=RECHTS(A1;LENGTE(A1)-VIND.ALLES(",";A1)-1)&" "&LINKS(A1;VIND.ALLES(",";A1)-1)

 

Upvote 0

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,465

Office Version

1. 365

Platform

1. Windows

• Oct 5, 2014

• #9

Based on the link VoG posted, I believe the formula I posted in Message #2 translates this way...

=DEEL(A1&" "&A1;VIND(" ";A1)+1;LENGTE(A1)-1)



EDIT NOTE: Or, based on what you posted in Message #8, possibly this....

=DEEL(A1&" "&A1;VIND.ALLES(" ";A1)+1;LENGTE(A1)-1)

 

Last edited: Oct 5, 2014

Upvote 0

I

IvoOvermars

New Member

Joined

Aug 6, 2010

Messages

12

• Oct 5, 2014

• #10

Yes, that last one also works .

Thank you both, enjoy your weekend

 

Upvote 0