Do You Know by GURUS

Getting the Last Position of a Character using Excel Formula

=RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,"/","@",LEN(A2)-LEN(SUBSTITUTE(A2,"/",""))),1))
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Feeds

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Followers

Favourites

  • Abu Dhabi, Sharjah - Traffic Fine Inquiry
  • Al Quran in Flash
  • Al Quran Navigator
  • Change of Website Design
  • Developing for Dynamics GP by David Musgrave
  • Learn Different Languages
  • Microsoft Solutions for Small and Medium Business
  • Online Free Image Editor
  • PTA - Sim Information System
  • Punjabi Language, Literature and Culture
  • RTA - Traffic Fine Inquiry
  • SMS Confirmation Website
  • UAE Visa Validity Information - e DNRD

Contents

2012 R2 429 Accessing Internet Account Alias Account Rollups Account Segment Names Account Type Active Directory Active/Passive ActiveX Adding Extra Information Address and Sales History Administrators Ads Adsense Advanced Lookups AI Alternative Anaylze General Leder Activity Another user APICS AR Artificial Intelligence Audit AX AX 7 Back Out Backup Balance Sheet Balancing Received not Invoiced Bank Module BCP BI Birth Birth Day BOM Bulk Copy Process Business Intelligence CA-Clipper Cash Flow CAVO CDA CEIP Certification Certified Supply Chain Professional Changer for GP Chart of Accounts Client Settings for Business Portal Clipper Clustering Collation Color Codes Colour Codes Commands Company Data Archive Configuration Manager Copy Database Copying Security Roles Copying Shortcuts Correct Posted Transaction Cost Basis of an Asset Crack CRM CRM Online CSCP Cursor Cusotmers or Vendors Custom Link Custom Smartlist Customer Experience Improvement Program (CEIP) Customer Summary Sales Amount Dashboards Database Database Maintenance Date Change Message Date Errors Day DBase Defferal Delete Delete Stranded User Activity Deleted Deleted Records Deleted Rows Deleteing Parts Desktop Shortcut Keys Devaluing Inventory Dex.ini Dexterity Dexterity Run time Error Difference Different Printer Distributions in Payables downloads Duplicate or Copy Pricelevel DYNAMICS Dynamics 365 Dynamics AX eBanking eConnect End Year Process Excel Expense Export Extender FAQ Feed Feed Management Systems Feeds File Recovery Fin 630 FIN630 - Investment Analysis And Portfolio Management Finance Financial Financial Flash Report Financial Stability Find Find Column from Table Find Field Value in Database Find Table Size of the database Flash Flow Foxbase FRx Functions Gain Game GDB General Ledger Google Adsense GP GP 2010 GP12 GP2013 Great Plains Green Bar Search Window Gross Profit Calculation Hidden Hidden Codes Hidden Games Horizontal Scroll Arrows HP HP Notebook HTM HTML HTML Color Code Chart Important Important Notes Importing Reports Improving Financial Reporting Incorrect Distributions Information Information Lookups INI Integration Interface Internet Internet User Defined Fields Inventory Investment Analysis and Portfolio Management IP Address Keyboard Shortcuts Keypress Kill Open Processes Last Appearance LCS Learning Letter Writing Assistant Lifecycle services Login Macro Macros Maintenance Management Reporter Matching Invoices to Receipts mbs Meetings Mentor Microsoft Microsoft Business Portal Microsoft Dynamics AX Microsoft Dynamics CRM Microsoft Dynamics GP Microsoft Dynamics GP 2010 Microsoft Excel Microsoft FRx Microsoft Outlook Microsoft SQL Server Microsoft Word Microsoft_Dynamics_GP.vba Missing Lines Modules Mouse Multiple Bill To Addresses Multiple Vendor PO. mySQL Navigation Bar Negative Cash Flow New Database Numeric Keypad Oracle Outlook Password Patches Payments Due Phantom PO. Item Lookup Posting to Closed Year Power Platform Print Different Sales Docs Process Product List Profit and Loss Project Reference Purchase Order Qlikview RDBMS Reconcile Inventory while Posting Reconciliation Reconciliation Payables Work Reconciling Subsidiary Ledger Recover Recovery Recurring Journal Entries Recurring Journal Entry Remembering Processes with Ad hoc Workflow Reminder Report Report yeilds no data in FRx Reporter Reports Reprint Printed Picking Tickets reset password reset root password Reset System Password Restore RetrieveGlobals9.Dll Reverser Right Roles root RTW Runtime Error SA Password SA. Password Sales Sanscript SAP SAP R/3 SAs Save Saving as Sheet Script Scripts Search Search Engine Optimization Security Security Access Security Settings Security Tasks Segment Width SEO Service Packs SharePoint Sheet Shortcut Shortcuts SIM Card Simplify Account Reconciliation with Smartlist Builder Smartconnect Smartlist Smartlists Default GoTo Window Smartlists Run Faster SmartSort Software Architectural Patterns SOP Transacion Entry SOP with No Lines or Incorrect Totals Speeding Up Account Entry SQL SQL Instance SQL Query SQL Reporting Services SQL Server SQL Server 2005 SQL Server 2008 SQL Server Management Studio Strange Terms Supply Chain SWF Switches Synchronize Time with Windows Domain System Database System Design System Requirements Test Environment to Production Environment The Closer Tips Track Ball Track Ball Mouse Numeric Keypad Hub Tracking Numbers Sales Orders Transparent Background of SWF Tricks Tune-Up Tools Un-Delete Un-Erase Undo Bank Reconciliation Unloack User Up-gradation Up-grade USB Flash Drive User Date User Preferences VBA VBA6 Vendor Removal from Inventory Items Version Version Retirement Date Virtual PC Visual Basic Application Void Partially Applied AP Payment Voiding Check Vouchering Payables VPC Web Ads WebMaster What's New Who Entered Transaction Windows Windows 7 Windows Commands for Administrators Windows Server Windows Server 2008 Windows XP Windows XP Sales Winword WMI Configuration Error Word Worksheet Xapta XBase Zero Amounts Formating in FRx

Blog Archive

  • ►  2024 (3)
    • ►  May (3)
  • ►  2023 (2)
    • ►  December (2)
  • ►  2022 (1)
    • ►  November (1)
  • ▼  2019 (10)
    • ►  December (1)
    • ►  November (1)
    • ▼  September (1)
      • Getting the Last Position of a Character using Exc...
    • ►  March (6)
    • ►  February (1)
  • ►  2018 (3)
    • ►  September (1)
    • ►  April (2)
  • ►  2017 (6)
    • ►  December (1)
    • ►  November (1)
    • ►  August (1)
    • ►  July (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2016 (16)
    • ►  December (2)
    • ►  November (3)
    • ►  October (1)
    • ►  June (4)
    • ►  May (6)
  • ►  2015 (7)
    • ►  November (1)
    • ►  September (1)
    • ►  August (2)
    • ►  May (2)
    • ►  March (1)
  • ►  2014 (2)
    • ►  November (1)
    • ►  February (1)
  • ►  2013 (12)
    • ►  October (1)
    • ►  August (1)
    • ►  July (1)
    • ►  April (7)
    • ►  February (2)
  • ►  2012 (6)
    • ►  May (1)
    • ►  April (4)
    • ►  March (1)
  • ►  2011 (14)
    • ►  December (7)
    • ►  November (1)
    • ►  July (1)
    • ►  January (5)
  • ►  2010 (123)
    • ►  November (2)
    • ►  October (19)
    • ►  September (102)

DISCLAIMER

Contents from other websites are provided for the convenience of users. We are unable to provide any warranty regarding the accuracy or completeness of the content of such sites, or the reliability, quality or effectiveness of any products provided through external websites. A link to an external site does not imply an endorsement of the views, information or products provided or held by such websites.
Simple theme. Theme images by gaffera. Powered by Blogger.