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

Cut at semicolon/switch around data

Aslan, Anne: Operations (xyz)

Hi,

I have a list of names ike the above, is there any code/formula i can run which will cut at the semi-colon, remove the apostrophy and switch the name around so it reads,

Anne Aslan

A big ask, i know!!

Thanks,
Seamus
0
Seamus2626
Asked:
Seamus2626
  • 2
  • 2
1 Solution
 
Jared_SCommented:
If the value is in The A1 cell...

=RIGHT(A1,LEN(A1)-(FIND(",",A1)))&" "&LEFT(A1,(FIND(",",A1)-1))
0
 
NBVCCommented:
Assuming string in A1, try:

=TRIM((MID(LEFT(A1,FIND(":",A1)-1),FIND(",",LEFT(A1,FIND(":",A1)-1))+1,255))&" "&LEFT(A1,FIND(",",A1)-1))
0
 
Seamus2626Author Commented:
Beautiful guys, thank you very much

Seamus
0
 
NBVCCommented:
As far as I can tell, the solution offered by Jared_s does not cut out the text after the colon as you requested....
0
 
Seamus2626Author Commented:
Thanks all
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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