LinkBack URL
About LinkBacks
Hi Friends,
One cell contain =230+110+290.
I want part of the above 3 numbers in another cell.
Thank you.
Hi Friends,
One cell contain =230+110+290.
I want part of the above 3 numbers in another cell.
Thank you.
Hi,
Is this a string of text or a formula which results in 630?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Manually entered.....
Do you have the FORMULATEXT function in Office 365? I am presuming you do. If so, you can use that along with the LEFT, MID and RIGHT functions to extract the numbers.
e.g. =RIGHT(FORMULATEXT(A1),3)
will result in 290.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you AliGW,
If we have 5 numbers.......
Because some cells have 4 to 5 numbers...
OK - I've had fun trying to guess what your data looks like. How about posting a realistic sample with some expected outcomes?
We receive goods many times from one supplier, and we record like =22+35+210+31+11, like that. After that we can get any special scheme for some of it. Like 2nd delivered 35 have 2% rebate, want to prepare other form.
We have much more columns, so we dont want to create more columns for goods receiving. One of the reason is all are same price
Can you put this onto an Excel sheet, WITH your expected results? I'm not clear what you need...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi,
Are these cells strings of text or a formula which results in 630.
Strings of text
In below attached file, I want formula for B3 cell
You need to change one of your Excel options
File...Options..Advanced scroll down to 'Display options for this sheet' and untick the checkbox
The one called "show formulas in cells instead of their calculated results" needs to be unchecked, to be precise...
Yes, i know, i send you in that format to understand easly
Rajesh. You have confused us all, I think. Tell us all again EXACTLY what is in what cell and what you want done with it....
Ok, Glenn,
I have entered some data in B2, Total 5 numbers,
I want one of that 5 numbers in B3. Some times 1st number, some times 2nd number etc. Let say in this sheet I want 4th Number in B3
Thank you for your patiency.
How/where will you indicate which one you want?
No reply... you're probably asleep. So try this out.
let say I want formula for B3 like "B2 4th number"(my intention, not formula),
Sorry, I don't know is it possible or not. I did't see any where like this, but my boss........
I think Excel is meant to work it out from the contents of A3: 2% REBATE FOR 4TH DELIVERYOriginally Posted by Glenn Kennedy
Rajesh. Does the sheet I attached come close?
Excellent boss.... Thank you.....
One small request, Can we include C column number into formula, Then I can change number in Formula.......
Can I suggest that since you want to analyse a series of data values that you consider the way you are currently capturing and recording data. For any serious analysis you should collect data in a normalised 2 dimensional table. Once you have that then you can use Excel's various tools and functions to analyse it in many ways. This approach would be much simpler than jumping through hoops to interpret and analyse strings of varying lengths.
Yes, I saw the sheet, But in my sheet values have "=", because that cell must have total value.
You could do that. but you would need to be mad to want to do so. The formula is fairly complicated. But, if (in D2) you wanted to change it, you would have to replace the 3 references to C2 with the number 3.
You really are overcomplicating this.
Record 5 records for Toys referencing each with (in this case) the digits from 1 to 5. Then the solution is either an autofilter or a simple lookup function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks