Excel separate postcode formula

Here we go (H2): "Someplace XX8 8XX"

=RIGHT(H2,(LEN(H2)-FIND(" ",H2)))

kinda works, except if Someplace has additional spaces in it.

Looks like you could do a find from the right to left and make it more fool proof but that would involve a bit of VBA.

Comments

Post a Comment

Popular posts from this blog

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

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