I’m struggling with the final part of this formula to add the country abbreviation followed by “.index”
The data format needs to be as follows: FIRSTNAME(Initial in Uppercase)LASTNAME(lowercase)COUNTRYCODE.INDEX
Where do I put this part in what I have so far?
=IF(COUNTIF(V5,”English“),””,PROPER(LEFT(D5)&TRIM(RIGHT(SUBSTITUTE(F5,” “,REPT(” “,99)),99))))
I tried to put CONCATENATE(X5,”.”,”INDEX”) somewhere, but I am sure I am doing something wrong here, clearly!
New contributor
Samantha G is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.