TEXTBEFORE and TEXTAFTER
The new functions TEXTBEFORE and TEXTAFTER allow you to extract subtext easily on a delimiter.
text manipulation
Meaning of the sign & in Excel?
What does mean the sign & in Excel? This sign is very important in many situation to link 2 cells together.