Notifications
Clear all
Topic starter
Hi Team,
I have load some names from ERP as attached. I will require to have specific name as expected description.
Please let me know how to do that.
Thank you.
Regards,
Aye
Posted : 18/03/2021 3:25 am
Hi Aye Mu
See if this helps.
Please note that they are ARRAY formulas.
Sunny
(Excel 2019)
Posted : 18/03/2021 10:06 am
Hi Sunny,
Please can u update the formulas to get the companies names. Please check attached file.
Thanks;
Bill
Posted : 18/03/2021 1:39 pm
Hi Bill
Try
=TRIM(LEFT(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0123456789"))-1))
Sunny
Posted : 18/03/2021 10:26 pm
Topic starter
Many thanks, Sunny.
It is a great help. the formula for Bill will be a useful one too.
I do not have the numbers at the back so far.
thank you.
Posted : 18/03/2021 11:17 pm
