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 the shop./n
What the formula should do?
I would like to return the max string length (len()) before the characters "/n" within a cell.
According to the Cell A2 content, it should return the value "41" since:
"Press the cross button to enter the shop." = 41 characters
"You have earnt:" = 15 characters
"1000 points" = 11 characters
If you can do it with a regular Excel formula, it would be more simple for me.
However, I understand that only some solutions can be done via VBA (I already have some running macros in the same sheet).
Thanks in advance for your help if someone knows![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Stephane
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 the shop./n
What the formula should do?
I would like to return the max string length (len()) before the characters "/n" within a cell.
According to the Cell A2 content, it should return the value "41" since:
"Press the cross button to enter the shop." = 41 characters
"You have earnt:" = 15 characters
"1000 points" = 11 characters
If you can do it with a regular Excel formula, it would be more simple for me.
However, I understand that only some solutions can be done via VBA (I already have some running macros in the same sheet).
Thanks in advance for your help if someone knows
Stephane