• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1125
  • Last Modified:

Text Formula to rearrange order of text in cell

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
Coxy31
Asked:
Coxy31
  • 2
1 Solution
 
CORBETTMJCommented:
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
 
Coxy31Author Commented:
this is exactly what I was looking for! Thanks
0
 
CORBETTMJCommented:
You're welcome. Thanks for the grade.
Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now