Solved

Text Formula to rearrange order of text in cell

Posted on 2008-10-17
3
1,078 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 500 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Outlook Free & Paid Tools
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

713 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