LinkBack URL
About LinkBacks
Hello everybody,
I want to create a normal function or vba function to split text in multiple non adjacent cells.
Expected vba function:
split(e3,h3,k3,n3,q3)
See the attachment
Hello everybody,
I want to create a normal function or vba function to split text in multiple non adjacent cells.
Expected vba function:
split(e3,h3,k3,n3,q3)
See the attachment
Last edited by leprince2007; 12-14-2017 at 07:08 AM.
Where's the code you've been working on?
Want to get your question answered quickly?
- Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
- On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
- Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
- Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
- Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
- If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
Ben Van Johnson
If you use this formula in E6 to E15:=
Formula:
Please Login or Register to view this content.
Then this function will return your results
Please Login or Register to view this content.
Last edited by mehmetcik; 12-14-2017 at 08:43 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you for your reply,but I have some notes:Originally Posted by mehmetcik
If you use this formula in E6 to E15:=
Formula:Please Login or Register to view this content.
Then this function will return your results
Please Login or Register to view this content.
1-I want the formula to be like this:
Splitter(e3,h3,k3,n3,q3)
2- If I put the formula in any other place ,it gives me error.I want to solve this error.q
Simple put the correct range(s) in SPLITTER.
=splitter($E$3:$Q$3,$E$6,3)
Red is the input range, green start of the output range.
Could not be much simpler.
Here is a formula solution
Enter formula in E6 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you sirHere is a formula solution
Enter formula in E6 and copy down
Formula:Please Login or Register to view this content.
Well done
Can you explain your wonderful formula,please??Here is a formula solution
Enter formula in E6 and copy down
Formula:Please Login or Register to view this content.
Because I cannot understand it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks