Page 2 of 2 FirstFirst 12
Results 11 to 11 of 11

Thread: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

  1. #11
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,212
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Quote Originally Posted by HelenL View Post
    1) single cell A1 Row 2 but will pull the formula down through the rest
    2) yes
    3) yes
    4) yes
    5)yes this is the year
    6) yes
    Since you answered yes to all my questions, this formula should also work...

    =LEFT(REPLACE(A1,8,0,RIGHT(A1,3)),14)
    Last edited by Rick Rothstein; Jun 18th, 2019 at 04:08 PM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •