Concatenate 2 fileds

[david20100]

Hi,

I want to Concatenate my invoice number (string) and the first 2 characters of my part number (string also).  Can't find how to only keep the first 2 letters of the part number

thanks

[DultonM · Accepted solution]

Hi @david20100!

Are you performing this concatonation in a Formula tool? If so, just use the Left function! Example: [Invoice Number Field] + Left([Part Number Field],2) Hope this helps!

[david20100]

Easy as that

Thanks