Solved

How Can I switch string

Posted on 2016-09-24
3
34 Views
Last Modified: 2016-09-24
Hello EE,

Can someone please help me with an excel formula to remove comma and switch the string before the commas to the end of the string? I have the following example:

III, Wallace James
Janet Rhodes,
Adu, Mary Ann

Should be

Wallace James III
Janet Rhodes
Mary Ann Adu

Thanks in advance for your help
0
Comment
Question by:fb1990
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41813906
Assuming your string is in A1 then try this.....
In B1
=TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))&" "&REPLACE(A1,FIND(",",A1),255,""))

Open in new window


Edit: Or this after including the error handling.
=IFERROR(TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))&" "&REPLACE(A1,FIND(",",A1),255,"")),A1)

Open in new window

0
 
LVL 1

Author Closing Comment

by:fb1990
ID: 41813920
Thank you very much Sir.  Worked like a charm!
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41813965
You're welcome. Glad to help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question