asked on Excel: Split names into columns Macro?
We have a document filled with tons of data. There is one column that states people's names. Some with middle names, some with not. But the problem is it's all in one column.
What we need is a macro that can separate all of these into 3 separate columns.
I have a example of what I'm trying to say attached to this.
Thanks!
example.xlsx
What we need is a macro that can separate all of these into 3 separate columns.
I have a example of what I'm trying to say attached to this.
Thanks!
example.xlsx
Microsoft Excel
Last Comment
dlmille
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
(Sorry I'm only familiar with macros) with that VB is there a way to specify columns such as A:A go to A:C? Because when we get this data it's filled with like 50 columns of other data that's not names, but other data.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
There OUGHT to be a SPLIT function at the formula level, lol, but this approach is the closest I've found.
Dave
Dave
ASKER
dlmille that looks very good!
One question, what values do I change if I want to change column or rows?
I tried changing some values and it just messes it up
One question, what values do I change if I want to change column or rows?
I tried changing some values and it just messes it up
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks!
I'm sorry guys, but I've thought about this for a couple days, and feel that too much effort was spent by each of us with excellent solutions to warrant a B grade, and therefore I'm objecting.
@Pancake_Effort - please read the following guidelines for grading:
Grading Guidelines
A: The Expert(s) either provided you with a thorough and informative answer or with a link to information that answered your question.
B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution but you needed more information to complete the task.
C: You have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information, and the answer, after clarification, lacks finality or does not address the issue presented
Based on my re-read, it does not appear from my perspective that you needed more information to complete the task - in fact, it appears your understood the proposed solutions perfectly and were very happy with the result.
Dave
@Pancake_Effort - please read the following guidelines for grading:
Grading Guidelines
A: The Expert(s) either provided you with a thorough and informative answer or with a link to information that answered your question.
B: The Expert(s) provided an acceptable solution, or a link to an acceptable solution but you needed more information to complete the task.
C: You have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information, and the answer, after clarification, lacks finality or does not address the issue presented
Based on my re-read, it does not appear from my perspective that you needed more information to complete the task - in fact, it appears your understood the proposed solutions perfectly and were very happy with the result.
Dave