fahadferoz
Member
Please help me with the 2 formula problems. Can only use LEN, TRIM, SUBSTITUTE, and REPLACE. I tried with different combinations but could not do it. Any help will be highly appreciated.
Need TUTORING with LEN/TRIM/REPLACE/SUBSTITUTE. HELP.
- Thread starter fahadferoz
- Start date
- Status
fahadferoz
Member
AN EXERCISE.
pecoflyer
Well-Known Member
Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).
We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.
If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.
If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
fahadferoz
Member
really. then help me my friend.
fahadferoz
Member
Lier. Not cross posted. Stop abusing people.
fahadferoz
Member
any resemblance?? stop abusing post.
My bad, it was your other thread that was cross posted.
fahadferoz
Member
Again lying. No resemplance. I changed caused you said I had to change it to 'tutoring' if i needed help with any exercise like this.
OMG you are so hostile.
pecoflyer
Well-Known Member
Yes, I must say you are smart enough to post your homework / exercises on different forums which helps confusing people
Perhaps refresh your memory with your attitude in this thread https://www.excelforum.com/excel-ge...stance-with-vlook-up-formula.html#post5333001 ?
Please follow all forum rules, including remaining civil to one another.
It does appear that multiple threads have been created with very similar topics. For now, I'll give benefit of doubt. To OP, I would suggest starting a new thread and clearly asking for help with whatever part you are stuck with.
Bad question: How do I solve this using LEN & SUBSITITUTE?
Better question: I know how to use the LEN function, but how would I determine what part of the text to use with SUBSTITUTE?
It does appear that multiple threads have been created with very similar topics. For now, I'll give benefit of doubt. To OP, I would suggest starting a new thread and clearly asking for help with whatever part you are stuck with.
Bad question: How do I solve this using LEN & SUBSITITUTE?
Better question: I know how to use the LEN function, but how would I determine what part of the text to use with SUBSTITUTE?
- Status