https://www.infopathdev.com:443/forums/40.aspxFor browser form specific questionsenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/119925.aspxMon, 08 Oct 2018 15:01:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119925Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119925.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=119925You could use concat &amp; substring for this. concat(substring(LastName, 1, 1), substring(SSN, 6, 4)) should do the trick.https://www.infopathdev.com:443/forums/thread/119923.aspxMon, 08 Oct 2018 05:13:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119923runngun170https://www.infopathdev.com:443/forums/thread/119923.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=119923<p>I am trying to get a formula to&nbsp;pull the first letter from one field and concat it with the last four of a SSN.&nbsp;</p><p>&nbsp;Last Name would be Smith, SSN 000001234.</p><p>&nbsp;Output would be S1234.&nbsp;</p>