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

Indesign scripting - negative object reference

Quick reminder: When scripting Indesign a negative object reference means the "last" of something. eg myTextFrame.insertionPoints.item(-1).place(myTextFile); // the end of a text frame or from the Scripting guide: Note that you can use negative numbers to refer to the layers in the layers collection of a document. Layer  -1 refers to the last (bottom) layer in the collection. eg layer(-1); Beware of dynamic collections of objects. Messing with them will change references to items: http://cssdk.host.adobe.com/sdk/1.0/docs/WebHelp/app_notes/id_scripting.htm#Dynamic_collections_and_object_types
Read more

cURL to REST API

More curl goodness: curl -i -X PUT -H "Content-Type:application/json" \ http://localhost//restserver/index.php/api/key \ -d '{"level":10}' curl -i -X PUT -H "Content-Type:application/json" \ http://localhost//restserver/index.php/api/example/send \ -d '{"username":"me","password":"1234","level":10}' using a file as input: curl -i -X PUT -H "Content-Type:application/json" \ http://localhost//restserver/index.php/api/key \ -d @filename.json
Read more