LinkBack URL
About LinkBacks
Looking for the correct combination of Left, Right, Mid, or Substitute function to separate values into desired column. Desired outcome in B2:B29, C2:C29, D2:D29, G2:G29, H2:H29, I2:I27, M2:M27, P2:P27, and Q2:Q27. See sample file.
Thanks
Looking for the correct combination of Left, Right, Mid, or Substitute function to separate values into desired column. Desired outcome in B2:B29, C2:C29, D2:D29, G2:G29, H2:H29, I2:I27, M2:M27, P2:P27, and Q2:Q27. See sample file.
Thanks
Presumably columns B:D are meant to break out full names in column A. Are there really commas between given names and surname in column A? That'd be extremely unusual.
For that matter, F8 contains Sablan, Yankee Jr., but G2 shows the last name as Sablan and H2 shows the first name as Yankee Jr.. Given what Jr. usually means in English, why are you showing Jr. in H2 rather than G2?
In other words, your examples don't make sense. It looks like you just threw something together and expect the rest of us to read your mind to ascertain your intentions.
Try this. Pl see file with formulas.
Last edited by kvsrinivasamurthy; 05-02-2021 at 12:44 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand.
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.
kvsrinivasamurthy: phenomenal solution. Thanks a lot.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
AliGW: Marked closed. Thanks
Thanks for feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks