Seperate Text

  • Thread starter Thread starter DDH
  • Start date Start date
D

DDH

Thank you for all of your help. I have another question that I wondered
if it is possible. I have been working on it for two days and I am not
smart enough figure it out.
Here is the basic cell line, Extract and Reverse.

(Cell C2) ABC Company-Smith, Joe
The formula is in (D2) and the result would be Joe Smith

The foumula below works if there is no other " - " or " / " or anything
else in the cell.
I have tried all sort of things to always make it pick up the very last
" - " and disreguard all other characters and I don't know if it is
possible.
Thank you for your help and knowledge.


=RIGHT(C2,LEN(C2)-FIND(",",C2)-1)&"
"&MID(C2,FIND("-",C2)+1,FIND(",",C2)-FIND("-",C2)-1)
 
See one more reply at your original post.

DDH < said:
Thank you for all of your help. I have another question that I wondered
if it is possible. I have been working on it for two days and I am not
smart enough figure it out.
Here is the basic cell line, Extract and Reverse.

(Cell C2) ABC Company-Smith, Joe
The formula is in (D2) and the result would be Joe Smith

The foumula below works if there is no other " - " or " / " or anything
else in the cell.
I have tried all sort of things to always make it pick up the very last
" - " and disreguard all other characters and I don't know if it is
possible.
Thank you for your help and knowledge.

=RIGHT(C2,LEN(C2)-FIND(",",C2)-1)&"
"&MID(C2,FIND("-",C2)+1,FIND(",",C2)-FIND("-",C2)-1)
Click to expand...
 
Back
Top