Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Text Formula to rearrange order of text in cell

Posted on 2008-10-17
3
Medium Priority
?
1,109 Views
Last Modified: 2012-05-05
Hi,
I have data that appears in a cell as "Employee Name: Bloggs, Joe
I use a formula to extract the name only (MID(<CELLREF>,15,25) as the names can be variable.  This gives me the result in a cell showing Bloggs, Joe
is there a formula I could use that would extract the name from the cell in the following format: Joe Bloggs
0
Comment
Question by:Coxy31
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
CORBETTMJ earned 2000 total points
ID: 22738779
Hi

Try

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

Assuming the data's in cell a1

Regards

Mark
0
 

Author Closing Comment

by:Coxy31
ID: 31507070
this is exactly what I was looking for! Thanks
0
 
LVL 2

Expert Comment

by:CORBETTMJ
ID: 22738905
You're welcome. Thanks for the grade.
Cheers
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

824 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