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

HelenL

New Member
Joined
Nov 17, 2008
Messages
26
Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

Help appreciated - completely lost! :LOL:
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,316
Office Version
  1. 2010
Platform
  1. Windows
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:

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,109,116
Messages
5,526,921
Members
409,730
Latest member
mimipiz

This Week's Hot Topics

Top