I am trying to create a unique ID by combining the Preferred Name and Last Name of users. In some cases, the there is no preferred name and i would like to use the first name in that case: see below example of input data and output expected
Input
| First Name | Last Name | Preferred Name |
| Johnathon | Smith | John |
| Steve | Waugh | |
| Andrew | Flintoff | Andy |
| | | |
.
Output:
Unique ID |
| JohnSmith |
| SteveWaugh |
| AndyFlintoff |
i tried using the below formula but its not letting it run
If IsNull([Preferred First Name]) Then
Left([First Name]+[Last Name]
Else
Left([Preferred First Name] + [Last Name]
Endif
