How to move characters to the end of the string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to convert string to date 2
Set the Length of the Cell 1
Mapping integers to strings 5
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Searching the formula (not the value) for a text string 1
Calculate between start and end times 2
Conditional Formatting Amendment 2

Back
Top