Excel. Trim last, specific character from cell

Quick one, Excel, trim the last specific character from a cell

=IF(RIGHT(A114,1)="*",LEFT(A114,(LEN(A114)-1)),A114)

 That is all

Comments

Post a Comment

Popular posts from this blog

VMware Fusion bridge not working

I stayed up far too long last night figuring this out, so a post is warranted. VMware Fusion 3.1.3 on Mac 10.6.8 running Debian 5 (lenny) VM. NAT working fine but for some reason it just wouldn't work in bridged mode. I was trawling the t'internet for reasons why when it dawned on me, after reading that for some folk it worked with wired internet, but not wirelessly. If your wireless network is locked down to MAC addresses (access control) then your VM running in bridge mode won't be able to pick up an IP address because... ...it has a different MAC address! Obvious isn't it... grrrrr. I wanted to run in bridged (always used NAT before) so I could connect to services run by the guest OS from the host. I was playing with vnc4server and trying to connect to debian using the Mac Screen Sharing built in app. As an aside don't bother, the base install already comes with remote desktop (vino) which must get in the way as I had all sorts of difficulty. Runnin
Read more

bash nav

From here: http://www.skorks.com/2009/09/bash-shortcuts-for-maximum-productivity/ Ctrl + a – go to the start of the command line Ctrl + e – go to the end of the command line Ctrl + k – delete from cursor to the end of the command line Ctrl + u – delete from cursor to the start of the command line Ctrl + w – delete from cursor to start of word (i.e. delete backwards one word) Ctrl + y – paste word or text that was cut using one of the deletion shortcuts (such as the one above) after the cursor Ctrl + xx – move between start of command line and current cursor position (and back again) Alt + b – move backward one word (or go to start of word the cursor is currently on) Alt + f – move forward one word (or go to end of word the cursor is currently on) Alt + d – delete to end of word starting at cursor (whole word if cursor is at the beginning of word) Alt + c – capitalize to end of word starting at cursor (whole word if cursor is at the beginning of word) Alt + u – make uppe
Read more