Thread: Help with Date Format and truncating a field
View Single Post
 
Old 04-29-2013, 02:20 AM
mr starface mr starface is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Apr 2013
Posts: 2
mr starface is on a distinguished road
Default Help with Date Format and truncating a field
After some help with a merge document I am working on, have done some browsing but cant find exactly what I need. The merge is coming straight from an external application so I can only work on the data in Word.

First thing is I have a date field and I would like it to read "1st April 2013" but I cant see how to insert the "st" or "th" after the day number?

Secondly I have some fields that have the text I want but there is some additional text before or after what I need. For example "0123456 - Fred Smith" and all I want is "Fred Smith". Is there a command similar to "LEFT/RIGHT" in Excel I could use?

Thanks for any help
Reply With Quote