Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
96
Views
Topic starter
Please urgent help!
"3-4 Missing two" string in which I need to extract "3" so that I can calculate for the average in a long string. Please see pics below.
Thank you much!
https://docs.google.com/document/d/13sH8XRITU0APGAf_XlbiKw6w2vFUpfH7a-2L5QUDCcA/edit
Carolyn
Posted : 27/11/2019 11:18 pm
Hi Carolyn,
I couldn't open the Google link, but you can use LEFT to extract the first character in the text string. e.g.:
=LEFT(E2,1)+0
The +0 will convert it to a number that you can then add up.
Mynda
Posted : 27/11/2019 11:47 pm
Topic starter
Thank you so much Mynda! Really appreciate your help!
Posted : 28/11/2019 7:25 am
