Excel function for advanced Date manipulation

Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format


=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))

TM forum Programs

Advanced Service Development and Delivery
e.g. Activities relating to developing and delivering services in the complex value chain.
TM Forum Programs:
Enabling New Services Initiative, B2B Interfaces,
Product Lifecycle Management, Service Level Agreement Management,
App Stores, Service Delivery Framework, IPsphere,
Frameworx, Benchmarking

BSS/Revenue Management
e.g. Activities relating to managing the revenue stream in a service provider business.
TM Forum Programs: Revenue Assurance, Billing/Charging, Data Analytics, Fraud Management, Benchmarking

Business Transformation
e.g. Activities relating to optimizing business performance through processes and systems.
TM Forum Programs: Benchmarking, Frameworx, Information Framework (SID),
Application Framework (TAM), Business Process Framework (eTOM),
Integration Framework, Conformance Certification Assessment

Cable
e.g. Activities that enable MSOs and vendors to work together to provide guidance and best practices and standards based solutions for
operational needs for the cable market.
TM Forum Programs: Cable Interest Group, IPDR, Business Process Framework (eTOM), Business Intelligence/Data Analytics

Cloud
e.g. Activities relating to managing cloud services and removing the barriers to their widespread deployment.
TM Forum Programs: Cloud Initiative, Enterprise Cloud Leadership Council

Customer Experience
e.g. Activities relating to providing the optimal customer experience, including through efficient processes and data analytics.
TM Forum Programs: Managing Customer Experience, Benchmarking

Developing Service-Oriented Architecture Solutions
e.g. Activities relating to software development and integration of communications management systems
using service-oriented techniques and open, interoperable software solutions.
TM Forum Programs: TM Forum Developer Network, Frameworx, Business Process Framework (eTOM),
Information Framework (SID), Application Framework (TAM), Integration Framework,
TM Forum Interfaces, Conformance Certification Assessment

Government/Defense
e.g. Activities relating to collaboration on key industry issues relevant to defense organizations (including “military unique features”)
and the identification and development of supporting standards.
TM Forum Programs: Security Management, Federated Service Level Agreements

Management of Converged Networks
e.g. Activities relating to standardized network management of 4G, other broadband access networks, and the all-IP core.
TM Forum Programs: Managing Wireless/Wireline Networks, Managing All-IP Networks

Process Management
e.g. Activities relating to analyzing, defining, and deploying business processes across the communications service provider’s enterprise.
TM Forum Programs: Business Process Framework (eTOM), Benchmarking, Conformance Certification Assessment

Security
e.g. Activities relating to Cyber Security.
TM Forum Programs: Network Defense, Identity Management, Single Sign On

Service Quality
e.g. SLA Management