$$Excel-Macros$$ $$Reformatting First, Last and middle names$$

I have the following code which splits data from Column A so that column B has last name(s) and column C has first names and middle initial. How would I further code in excel to go only to Column C and put everything from the space on into a new column. Once done, I would want to delete all spaces

Re: $$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns

uot; & i + interval - 1).Copy > >     Range("D" & j).Select >     Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, > SkipBlanks:= _ >         False, Transpose:=True > > i = i + interval - 1 > j = j + 1 > Next > > End Sub > > On Fri, Aug 26, 2

$$Excel-Macros$$ Reorder last and first names

I have a column that has the data formatted like this: (This is a different column than previous post) Smith, John M Smith, Alex Jones, Mary Jackson Harris, Greg P Diaz-Garcia, Brenda Maria T etc I want it to look like this (Note these are separate columns and those having two last names have no

$$Excel-Macros$$ Re: Cut Data from Rows and Paste into Columns

Transpose would not work because every 4th record (or row) would need to go back to the first column, next row. original data could be in either an excel spreadsheet or a text file, whichever works best. thus 1 2 3 4 5 6 7 8 9 would look like 1 2 3 4 5 6 7 8 9 --

$$Excel-Macros$$ Cut Data from Rows and Paste into Columns

I have a series of spreadsheets that have data in them that needs to be formatted into 3 columns instead of one column. The data in Row 1 needs to go in row 1, column 1 Row 2 needs to go in row 1, column 2 Row 3 = Row 1, Col 3 Row 4 = Row 2, Col 1 Row 5 = Row 2, Col 2 Row 6 = Row 2 Col 3 Row 7 = R