Daily Archives: February 19, 2009


How to get everything after a character from a cell value. For e.g if we want to get everything after the first occurrence of a character in the value of cell We can use the SEARCH function along with other basic string functions. For example check the following formula…. =RIGHT(B59,LEN(B59)-(SEARCH(".",B59))) […]

Extract everything after a character in MS Excel