Montemontgo
Registered User.
- Local time
- Today, 03:58
- Joined
- Oct 25, 2004
- Messages
- 26
In a form I can easily combine and display the content of two text fields in a third text field with the formula =[field1] & [field2]. Very well. Now I would like to combine and display only the first letter of each of the two text fields. This I would expect to go somewhat like this =(letter,1,1[field1]) & (letter,1,1[field2]). How is the correct formula?