Hi all,
hope you are good, i am usinf a formula =SUBSTITUTE(UPPER(A1),"PCS","")+0 to find out numeric value but this is not working, kindly help to find this.
file is attached
Thanks.
Hi all,
hope you are good, i am usinf a formula =SUBSTITUTE(UPPER(A1),"PCS","")+0 to find out numeric value but this is not working, kindly help to find this.
file is attached
Thanks.
There is a hidden line break. Try this:
=--SUBSTITUTE(SUBSTITUTE(UPPER(A1),"PCS",""),CHAR(10),"")
You don't really need the UPPER function at all - Excel will look at the string case-insensitively:
=--SUBSTITUTE(SUBSTITUTE(A1,"PCS",""),CHAR(10),"")
Last edited by AliGW; 09-18-2019 at 01:49 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe,
=0+REPLACE(A1,FIND(CHAR(10),A1),4,"")
or,
=0+SUBSTITUTE(A1,CHAR(10)&"Pcs","")
or,
=0+LEFT(A1,FIND(CHAR(10),A1)-1)
or,
=0+LEFT(A1,LEN(A1)-4)
Regards
Bosco
Last edited by Bosco; 09-18-2019 at 03:35 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks Both, AliGW and Bosco,
its super, like cheers,
Thanks a lot
No worries.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks