Notifications
Clear all
Topic starter
In the attached file-
Extract the code inside the parentheses
And show it without brackets and without the space in the middle
And show it without brackets and without the space in the middle
thank you!!
lea
Posted : 17/06/2019 8:30 pm
Hi Lea
in cell B1 enter
=SUBSTITUTE(SUBSTITUTE(MID(A1,IFERROR(FIND("(W",A1)+1,FIND("(",A1)+1),50)," ",""),")","")
Hope thus helps.
Sunny
Posted : 18/06/2019 12:00 am
| =RIGHT($A1,FIND("(",$A1,1)+1) |
Posted : 20/06/2019 9:52 pm
