Concatenate Set Number of Characters

[mustufa2019]

I am trying to concatenate the first 7 characters of two fields (Field 1 and Field 7). Can I use formula tool for this?

Please see below for example:

Input:

Field 1	Field 2	Concatenate Outcome
NewYorkCity	Lime	NewYorkLime
WashingtonCommercial	LLC	WashingLLC
Ohio	CompanyLLP	OhioCompany

[AbhilashR · Accepted solution]

@mustufa2019 - yes, you could certainly use a formula tool.

Your formula would go something like:

Left([Field 1], 7) + Left([Field 2],7)

[mustufa2019]

@AbhilashR thank you! this worked!