return max string length

  1. S

    Return max string length before special character within a cell

    Hello, I would like to find the Excel formula (not VBA if possible) to know the longest string before meeting special characters within a cell. Where does it apply? CELL A1 Content The formula related to A2 CELL A2 Content You have earnt:/n1000 points/n/nPress the cross button to enter...

Some videos you may like

This Week's Hot Topics