🔐 Karlo Luiten

Linux, SIEM, Security, NextGen Firewalls and more
  • Home
  • LinkedIn
  • SELinux cheat sheet
  • CISSP Reference
  • Guide to Karlo
  • Contact

Excel return text right of last occurrence of string

 Uncategorized
Aug 132020
 

=TRIM(RIGHT(SUBSTITUTE(A1;” “;REPT(” “;LEN(A1)));LEN(A1)))

 Posted by karlo at 09:40

Sorry, the comment form is closed at this time.

  Update RHEL/CentOS from local repo (iso/cd)   Simple wireshark filter host+port

Posts

  • Indent HTML using tidy
  • Github what repos have you contributed to (graphql)
  • Debian VM as GW routing through VPN (tun) with nftables
  • Guacamole broken (Creation of WebSocket tunnel to guacd failed)
  • mount LVM2_member
  • List all ansible facts (facter puppet)
  • RPM only list/query package names
  • Mount raw ovirt / kvm disk
  • Linux remove last newline from file
  • nc in powershell (test remote open port/tcp)
  • Simple wireshark filter host+port
  • Excel return text right of last occurrence of string
  • Update RHEL/CentOS from local repo (iso/cd)
  • Pihole CORS problems
  • Move cygwin to different disk, including services
  • ubnt / ubiquiti edgerouter passwordless login ssh keys
  • Convert m4b to mp3 on Centos/Fedora using ffmpeg
  • Bash remove spaces from file names
  • AWK print longest line in file
  • Outlook unblock “unsafe” attachments
  • Excel conditional formatting search for literal question mark [?]
  • NPM (node) install fail as root
  • Windows “File is open in another program” (lsof in windows)
  • Extend a LVM-based swap partition
  • Fix bricked firmware update jabra (evolve)
  • Tmux save all output (history) to file
  • Upgrade dumb shell to interactive shell (tty)
  • Excel return last line of multi line cell
  • Keeping a (GitHub) fork up to date with upstream master
  • MySQL / MariaDB DB and user creation
  • AutoRecon over proxychains
  • Set scp port
  • Find Linux architecture without arch command
  • GNOME add minimize maximize
  • Linux run (ELF) binary without execute rights
  • Linux perform action on file change (like recompile or re-render)
  • Compiling: “bad register name `%rsp'”
  • Problem building Virtualbox modules on Centos (cannot generate ORC metadata)
  • Vim case insensitive searching /\csearch
  • Find windows version from commandline (cmd)
  • Windows identify user (‘whoami’ is not recognized as an internal or external command,)
  • Running compiled code sh: [10665: 4] tcsetattr: Invalid argument error
  • Bash sort IPs naturally
  • Sample systemd unit file
  • bash add IP in PWD to variable for easy reference
  • Easy AutoRecon summary (bash)
  • Vim use space to run macro q
  • Vim show some lines after cursor
  • Proxychains on fedora / centos7
  • Thunderbird hidden option: sync all subfolders
  • Metasploit using grep (no pipes | )
  • SQLMap pentesting answer Yes (or default) to questions
  • Bash while loop input (stdin reading from while-input) fix
  • Cross compiling error mingw32: Windows.h: No such file or directory
  • Use ls in cmd.exe
  • Vim jump to specific character (number) in (long) line
  • XFCE Focus follows mouse
  • Go compile error checksum mismatch (lnd)
  • Windows find file recursive cmd
  • Track data usage using iptables
  • Openvas service start timeout
  • Centos 8 enable cockpit (minimal install)
  • Print ansible facts for a server
  • Centos 8 restart network
  • nc/netcat smtp servers (tcp/25) not responding to commands
  • Libreoffice delete write protected content
  • Kali/debian update one package only
  • Fix “failed to start jnprTdi”
  • LVM device excluded by a filter (mpath / multipath )
  • systemctl Failed to execute operation: Access denied
  • Outlook search folder for calendar replies
  • Virtualbox copy files and clipboard
  • Rpmfusion fedora and h264/codecs
  • xfce terminal unsafe paste
  • Spotify on fedora
  • xfce4 terminal shortcut
  • Fix: Digital ID name cannot be found by underlying security system
  • Firefox memory and CPU profile
  • Bash array operations and examples
  • Unit someting.mount is bound to inactive unit
  • Bash color variables
  • Excel clear all filters shortcut: alt-dfs
  • Bash add UTF8 (UTF-8) BOM to file
  • Certbot centos 7
  • Get x11 forwarding working on Centos 7 & Putty & Xming
  • Reset ILO via SSH
  • Auto root login Centos 7 / EL 7
  • Set up TOTP/Google authenticator on Centos 7
  • LVM show pvmove status
  • Ovirt POSIX storage failing – Error while executing action Add Storage Connection: Problem while trying to mount target
  • Found ArcSight parser functions
  • Linux screencasting with overlays and all: OBS
  • Tail: prepend file name to tailing output (bash)
  • Node Rocketchat npm fibers not running ( versionGLIBCXX_3.4.20 not found ) on centos/rhel
  • Personal (manual) template for internal hosts
  • ArcSight upgrade/install “Unable to carry out the checkLocalHost check.”
  • Bash suppress all output of script (echo off – style)
  • Certmonger defunct RHEL7
  • Install Domoticz on Centos 7
  • Dell get serial / service tag on windows / linux

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2011 Karlo Luiten Suffusion theme by Sayontan Sinha