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

Whoa!

Something else I've started and won't finish..? Still, I've wanted to run my own blog/dump for a while now. Somewhere to post my nick nacks/rants/musings/tips. Originally on a DIY home server but never quite got it together and couldn't stand the fan noise coming from under the stairs :D
Read more

Unix titbits

find . -newermt '30 seconds ago' -print find ('.' = files in current dir and subfolders thereof) -newermt (an option, see man page) (files changed within) '30 seconds ago' -print (don't forget to print the results to std output) :D find . \! -name ".DS_Store" -type f -print find only plain/standard files (-type f) NOT called .DS_Store (\! -name ".DS_Store")(NB escaped !)
Read more