Extract everything after a character in MS Excel

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))) will give "BKG" if the value in B59 is "SKC12.BKG"

The above formula will give us everything towards the right of first occurrence of “.” in the value of cell B59.


Leave a Reply

Your email address will not be published. Required fields are marked *