Forum Discussion

Kdube22's avatar
Kdube22
Copper Contributor
Nov 03, 2021
Solved

Replace position abbreviation by initials for Job Title/Initials

Hello,    I am needing to create a conditional format in the case that I type an acronym for the job title in one box, it will fill in the initials for the person responsible. For example, I need a...
  • SergeiBaklan's avatar
    Nov 03, 2021

    Kdube22 

    That's not conditional formatting, that's one of lookup (XLOOKUP, INDEX/MATCH, etc). But only if to add initials into another cell. If replace position abbreviation by initials in the same cell that's with VBA programming, not my territory. If so perhaps someone else could help.

Resources