LinkBack URL
About LinkBacks
hi guys i m trying to slpit the required word in excel. i only required Easy mudra word
CTQ1234567 TRANSFER TO 12345678911 EASY MUDRA PRIVATE LIM /
hi guys i m trying to slpit the required word in excel. i only required Easy mudra word
CTQ1234567 TRANSFER TO 12345678911 EASY MUDRA PRIVATE LIM /
Please provide a sample workbook with at least 15-20 rows of sample data and expected outcomes. We need to understand what patterns emerge in order to find a logic to offer a solution. One random example does not give us enough to go on.
Attach a workbook, please.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I attached files and highlighted the data and show an example of what I need in the "L" Row of the "RAW" sheet name
The best that I could come up with is:
1. Make a table of terms as modeled in column X
2. Populate column L using:Formula:
Please Login or Register to view this content.
3. To add to the table select cell X12 and press the tab key > the formula in column L will automatically include the new term(s)
Note that most terms are listed more than once in column D so listing 11 terms in column X takes care of most of the 41 rows in column D.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks