How to concatenate upper case of substrings?

[ArtK]

I have 2 columns with headers First Name and Last Name
how would I take
first 4 characters of First Name, first 4 characters of Last Name, change to uppercase, and then concatenate into a new column Photo Name

In a statistical package, this does it: multiple lines only need for readability
string PhotoName(A14).
COMPUTE PhotoName= CONCAT(
(upcase(char.substr(Lastname,1,4))),
(upcase(char.substr(Firstname,1,4))),
'01.jpg').



Last Name First Name Photo Name
Smith John SMITJOHN01.jpg
Doe Janet DOE JANE01.jpg
Washington George WASHGEOR01.JPG

[etaf]

A sample spreadsheet with expected results would help as per the yellow banner above
is the name all in 1 cell
and ONLY 2 names first and last separated by a space
If the first name is 2 character
Jo Fred
then what would the first 4 characters be
JO F
and say the name is 3 x 3 Sox Joe

[mehmetcik]

If Names are in A1 and B1 then

Formula for C1 =upper(left(A1,4))& upper(left(B1,4))

[AliGW]

If you have no further need of help, then please mark the thread as solved, but don’t post-edit your posts.

I will mark this as solved for you today to avoid wasting our members’ time.