quote:

---

Originally posted by Ojc
Insert a columm next to the names, then highlight the entire columm, then click on DATA then TEXT TO COLUMMS then select FIXED WIDTH then click NEXT move the line between the first name and surname then click NEXT then FINNISH and you are done.

---

quote:

---

Originally posted by loafofbrett

quote:

---

Originally posted by Ojc
Insert a columm next to the names, then highlight the entire columm, then click on DATA then TEXT TO COLUMMS then select FIXED WIDTH then click NEXT move the line between the first name and surname then click NEXT then FINNISH and you are done.

---

surely that only works if the first names are all the same length

---

quote:

---

Originally posted by Chris Bingham
Too Easy

1 - Highlight the column with the Full Names and do a find and replace. Find a single space (just hit the space bar once) and replace with a comma (,)

Your full names column will look like this:-

Chris,Bingham
Dave,Collins
etc

Now do Data>Text To Column,

Select Delimited then next
Choose Comma as a Delimiter then Next
Choose Destination as this will mean you can place your 2 next columns away from your originating data
Click Finish
Proclaim me and Excel genuis.


[Edited on 18-08-2006 by Chris Bingham]

---

quote:

---

Originally posted by Ojc
Dave, send me the spreadsheet I can do it, but I'm not telling you how because its fcuking complicated

---

quote:

---

Originally posted by --Dave--
Chris/Jamie/for those who care,

It also works with using the spaces as the Delimiter, it then gives you the option to treat consecutive delimiters (spaces) as one or not, which I imagine would be good if there were middle names etc...

---