Try this:
=MID(A1,6,9)&"-"&LEFT(A1,4)
"Phil" wrote:
Hello,
I have a text value separated by dashes like this: S057-T11S-R06E, that sits
in Col A. I would like to MOVE the first 4 values (S057) to the end of the
string so that (S057) will sit AFTER (R06E). I would like to new string to
sit in Col B. How do I do that?
BTW, so that I can try to look this up for myself in the future, what type
of action best describes these actions (when I'll be trying to type in some
search text in the help section of Excel?
TIA for your replies!
Phil.
|