Text Calculation

[jasonwood]

I have one field containing a number, and another field containing (possibly) a list of text strings.

For example...

Field1: 55555

Field2:

12345123456

OASDG2345

0897ASDF0A

Now I want a calculation field that will list all of the items in field2 preceded by whatever is in field1...

55555-12345123456

55555-OASDG2345

55555-0897ASDF0A

Any ideas?

[BobWeaver]

Middle(Substitute("

[jasonwood]

The fields were backwards but I managed to figure that out.

Thank you Bob you've saved me again!