Display a city name based on a text
I want to display a city name based on a text, for example:
T1 = Toulouse
T2 = Bordeaux
T3 = Paris
T4 = ...
A cell in column A can contain a single character (T1) or several (T1 + T3). In column B I would like to display the name of the city according to the characters but I can't do it to combine 2 characters. My formula that only works for a single character is:
Ps: not possible to use SearchV in my file...
thanks in advance
Help Article Resources
Check out the Formula Handbook template!