SAP Security Authorization

Everything you need to know as a SAP Security Authorization consultant.

Thursday, 22 May 2014

Excel - Deleting text from cell a space character

Try this:

=LEFT(A1,FIND(" ",A1)-1)
at 01:01 No comments:
Labels: delete text after space, excel
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Search This Blog

Blog Archive

  • ▼  2014 (6)
    • ►  December (1)
    • ►  September (1)
    • ►  June (1)
    • ▼  May (1)
      • Excel - Deleting text from cell a space character
    • ►  April (2)
  • ►  2013 (16)
    • ►  November (1)
    • ►  October (1)
    • ►  September (2)
    • ►  August (1)
    • ►  June (1)
    • ►  May (2)
    • ►  February (2)
    • ►  January (6)
  • ►  2012 (14)
    • ►  November (1)
    • ►  August (4)
    • ►  July (4)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  February (1)
  • ►  2011 (69)
    • ►  November (1)
    • ►  October (7)
    • ►  September (7)
    • ►  August (6)
    • ►  July (6)
    • ►  June (10)
    • ►  May (32)

Labels

  • account (1)
  • active directory (1)
  • AD (1)
  • AUTHORITY-CHECK (1)
  • authorization check (1)
  • authorization groups (1)
  • authorization trace (1)
  • check (1)
  • child role (1)
  • codes (1)
  • configtool (1)
  • connectors (1)
  • CUA (2)
  • cup (1)
  • current date (1)
  • delete text after space (1)
  • display (1)
  • distribution list (1)
  • DL (1)
  • email (1)
  • error log (1)
  • excel (3)
  • export mitigation control (1)
  • ffid (1)
  • field description (1)
  • field name (1)
  • firefighter (1)
  • forumla (1)
  • grc (4)
  • grc 10 (3)
  • grc 5.3 (5)
  • group (1)
  • interview question (5)
  • java export (1)
  • java.lang.OutOfMemoryError (1)
  • jspm (1)
  • ldap (1)
  • lock attempts (1)
  • locked (1)
  • logon data (1)
  • logon status (1)
  • lowercase (1)
  • mass change user license (1)
  • mdg (1)
  • missing entry (1)
  • object (1)
  • object cannot be edited (1)
  • org level field description (1)
  • PA0105 (1)
  • parameter (1)
  • password (1)
  • password self service (1)
  • patch (1)
  • PERNR (1)
  • pfcg (3)
  • portal (1)
  • profile (1)
  • query (1)
  • remove duplicate (1)
  • replace with blanks (1)
  • Report (1)
  • repository sync (1)
  • role name special character (1)
  • RSCSAUTH (1)
  • RSUSR200 (2)
  • s_TABU_DIS (1)
  • sbwp (1)
  • Schedule RAR job (1)
  • scua (1)
  • scum (1)
  • se16 (1)
  • search by system id (1)
  • search from table (1)
  • security authorization (1)
  • SLG1 (1)
  • SNC (1)
  • snote 1719803 (1)
  • SO01 (1)
  • sod scan (1)
  • spro (1)
  • sqvi (1)
  • sso (1)
  • st01 (3)
  • stauthtrace (1)
  • su01 (1)
  • SU10 (1)
  • su21 (1)
  • SU22 (1)
  • SU24 (1)
  • su24 concept (1)
  • SU25 (1)
  • SUIM (1)
  • support pack (1)
  • system log (1)
  • system trace (2)
  • table for activity type (1)
  • tables (1)
  • tact (1)
  • tcode (1)
  • tcodes (1)
  • trace (1)
  • transaction (1)
  • uppercase (1)
  • user (1)
  • user email (1)
  • user lock (1)
  • user password status (1)
  • user type (2)
  • userid (1)
  • USLA04 (2)
  • USR02 (1)
  • usrid (1)
  • USRID_LONG (1)
  • valid to date (2)
  • validity (1)
  • version (1)
  • virsa (2)
  • workflow CUA system (1)
Related Posts Plugin for WordPress, Blogger...
Powered by Blogger.