katiapro93
Board Regular
- Joined
- Jun 25, 2009
- Messages
- 140
Hello everyone, hope there is an answer for my question. I am using Excel 2010 and I know there is a formula that does the opposite of the Concatenate formula, but I need a little more.
I have a column which I use in a larger spreadsheet which reads something like this: 10*3
I just need the number before the *.
I wrote a formula something like this: =MID($E3,3,LEN($E3)-3) and it worked well.
Problem is that it is not consistant in where I have 2 digits in front or in the back of the *. So I can have the following: 10*3, 5*6, 5*10.
Is there a way that I can put a formula in a cell to delete everything after the * and use as many digits as seen in the front of the *?
Thanks in advance for any help.
I have a column which I use in a larger spreadsheet which reads something like this: 10*3
I just need the number before the *.
I wrote a formula something like this: =MID($E3,3,LEN($E3)-3) and it worked well.
Problem is that it is not consistant in where I have 2 digits in front or in the back of the *. So I can have the following: 10*3, 5*6, 5*10.
Is there a way that I can put a formula in a cell to delete everything after the * and use as many digits as seen in the front of the *?
Thanks in advance for any help.
Appreciate the feedback!
