MS-Excel

Some Tips

• Extracting text after a certain character from a cell

Let cell B1 contain the text ‘This is a sentence with @ character in the middle.’

Formula to extract the text after the “@”

=RIGHT(B1,LEN(B1)-SEARCH(“@”,B1))

Expected output: ” character in the middle.”