Notifications
Clear all
Topic starter
hi guys
see below,there is full name ,Network ID and email ,how would you obtain the network ID if all the information was in one cell using an excel function
Carol Duprez CBD0213 [email protected]
Posted : 19/01/2017 11:19 am
Hi
Please give more sample data in an attachment. The example you gave is insufficient.
Sunny
Posted : 19/01/2017 7:03 pm
Hi Tererai
You can give this a try. The formula (in column E) is very long. Your sample contains non-printing character CHAR(160) and need to be removed (cleaned) and that is why the formula is much longer.
Maybe others can suggest a shorter formula.
Sunny
Posted : 19/01/2017 7:42 pm
