Hi,
I have in column D a list of employees names and last names:
Mark Jones
Tom Smith
Robert Brown Lewis
I need to split the names and last names and create two columns:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Names
[/TD]
[TD]Last names
[/TD]
[/TR]
[TR]
[TD]Mark
[/TD]
[TD]Jones
[/TD]
[/TR]
[TR]
[TD]Tom
[/TD]
[TD]Smith
[/TD]
[/TR]
[TR]
[TD]Robert
[/TD]
[TD]Brown Lewis
[/TD]
[/TR]
</tbody>[/TABLE]
Can someone please help me?
Thanks,
Edu
I have in column D a list of employees names and last names:
Mark Jones
Tom Smith
Robert Brown Lewis
I need to split the names and last names and create two columns:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Names
[/TD]
[TD]Last names
[/TD]
[/TR]
[TR]
[TD]Mark
[/TD]
[TD]Jones
[/TD]
[/TR]
[TR]
[TD]Tom
[/TD]
[TD]Smith
[/TD]
[/TR]
[TR]
[TD]Robert
[/TD]
[TD]Brown Lewis
[/TD]
[/TR]
</tbody>[/TABLE]
Can someone please help me?
Thanks,
Edu