Excel VBA for pulling apart text from a few cells and creating multiple cells of dataUse VBA to repeatedly...
Picking the different solutions to the time independent Schrodinger eqaution
What should you do if you miss a job interview (deliberately)?
What is Cash Advance APR?
Can a stoichiometric mixture of oxygen and methane exist as a liquid at standard pressure and some (low) temperature?
Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?
What are the advantages of simplicial model categories over non-simplicial ones?
What does "Scientists rise up against statistical significance" mean? (Comment in Nature)
Can the US President recognize Israel’s sovereignty over the Golan Heights for the USA or does that need an act of Congress?
Why is it that I can sometimes guess the next note?
Is this toilet slogan correct usage of the English language?
How should I respond when I lied about my education and the company finds out through background check?
Biological Blimps: Propulsion
Calculating total slots
Has any country ever had 2 former presidents in jail simultaneously?
Lowest total scrabble score
I'm the sea and the sun
The IT department bottlenecks progress. How should I handle this?
Terse Method to Swap Lowest for Highest?
Is there a way to get `mathscr' with lower case letters in pdfLaTeX?
Why is the "ls" command showing permissions of files in a FAT32 partition?
How does the math work for Perception checks?
Pre-mixing cryogenic fuels and using only one fuel tank
How to explain what's wrong with this application of the chain rule?
Why should universal income be universal?
Excel VBA for pulling apart text from a few cells and creating multiple cells of data
Use VBA to repeatedly generate random numbersVBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rowsExcel VBA: Skip an Entire Row from Processing If Condition Is MetHow to convert cells of a column to text in Excel 2007Excel - choosing numbers from bigger data setIs there a script somewhere or a way to modify excel that allows multiple selected areas to be copied and pasted?Text input and column width change for multiple cell and columns respectively at onceHow to skip cells when creating an array in excel?Excel Function/Macro to extract numbers from a comma delimited listExcel INDEX MATCH across 2 sheets & Update data with VBA
I would like someone to suggest the coding in VBA required to convert this data. Essentially B2 and B3 there will be multiple cells like there, even with more ";" and numbers after. The T and I won't change, but some don't always have T or I, they are just a single number.
The final output needs to be B12:C37
Any assistance?
Image of excel what I am after
microsoft-excel vba
asked 2 mins ago
JohnJohn
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I would like someone to suggest the coding in VBA required to convert this data. Essentially B2 and B3 there will be multiple cells like there, even with more ";" and numbers after. The T and I won't change, but some don't always have T or I, they are just a single number.
The final output needs to be B12:C37
Any assistance?
Image of excel what I am after
microsoft-excel vba
asked 2 mins ago
JohnJohn
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I would like someone to suggest the coding in VBA required to convert this data. Essentially B2 and B3 there will be multiple cells like there, even with more ";" and numbers after. The T and I won't change, but some don't always have T or I, they are just a single number.
The final output needs to be B12:C37
Any assistance?
Image of excel what I am after
microsoft-excel vba
asked 2 mins ago
JohnJohn
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I would like someone to suggest the coding in VBA required to convert this data. Essentially B2 and B3 there will be multiple cells like there, even with more ";" and numbers after. The T and I won't change, but some don't always have T or I, they are just a single number.
The final output needs to be B12:C37
Any assistance?
Image of excel what I am after
microsoft-excel vba
microsoft-excel vba
asked 2 mins ago
JohnJohn
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
JohnJohn
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
JohnJohn
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 mins ago
JohnJohn
1
asked 2 mins ago
JohnJohn
1
1
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
John is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
John is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1416542%2fexcel-vba-for-pulling-apart-text-from-a-few-cells-and-creating-multiple-cells-of%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
John is a new contributor. Be nice, and check out our Code of Conduct.
John is a new contributor. Be nice, and check out our Code of Conduct.
John is a new contributor. Be nice, and check out our Code of Conduct.
John is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1416542%2fexcel-vba-for-pulling-apart-text-from-a-few-cells-and-creating-multiple-cells-of%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
