foster5476
New Member
- Joined
- Jan 3, 2017
- Messages
- 7
Hello,
New to the forum and have read thru the tips before posting and hope my chart was loaded correctly. I also search for an answer to my question but found nothing.
Well I work out of Autocad but my tables are imported data from excel spreadsheets.
So what I am trying to do is get the my table to get the sum of the numbers with the S- or B- in front of the number and disregard the -L after the number.
I am not able to remove the prefix or suffix on the numbers. So is there a way to get only the number sum in a function form? Basically giving me 24+25+143+144=336
Thanks I hope this made sense.
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
New to the forum and have read thru the tips before posting and hope my chart was loaded correctly. I also search for an answer to my question but found nothing.
Well I work out of Autocad but my tables are imported data from excel spreadsheets.
So what I am trying to do is get the my table to get the sum of the numbers with the S- or B- in front of the number and disregard the -L after the number.
I am not able to remove the prefix or suffix on the numbers. So is there a way to get only the number sum in a function form? Basically giving me 24+25+143+144=336
Thanks I hope this made sense.
LIST | ||
QTY. | MARK | |
1 | s-24 | |
1 | b-25 | |
1 | s-143-L | |
1 | B-144-L | |
4 | X | |
Other info for me | ||
Other info for me | ||
336 <--where I need the total |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>