S
Slashman
Hi can anyone advise how I would go about splitting data in a cell.
EG I have a column that has first and last name in it separated with a
space.
IE
Bob Smith
How would I automatically look at each cell in the row and after the
end of the first name, cut the second name into its own row.
I should then have:
Bob in one cell and in the adjacent cell Smith.
Thanks in advance,
Cheers,
Aaron.
EG I have a column that has first and last name in it separated with a
space.
IE
Bob Smith
How would I automatically look at each cell in the row and after the
end of the first name, cut the second name into its own row.
I should then have:
Bob in one cell and in the adjacent cell Smith.
Thanks in advance,
Cheers,
Aaron.