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...