var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: separate names and last name in column
I know this is probably a very easy one but I can't figure out how to do this.
I just need to break up data in a column that contains last_name, first_name. I just want to create 2 columns, one with the last name and the other with the first name.
I appreciate any help!
Last edited by breban; 04-15-04 at
For first name use this in b1
For last name use this in C1
I figured out how to do it with 'text in columns'. I knew I'd kick myself once I figured it out!
Been there - done that!
Never hurts to have another tool in the arsenal, though.
Shades ... where would I put this code for the first name and last name if I want it to apply to all rows in column B and all rows for column C?
Also, is it possible to still have titles on the columns if you want all the rest of the rows for that column to use the same code to come up with first and last names?
Thanks in advance,
If you want to have column headings (in row 1), then your data begins in A2,
For first name use this in b2
For last name use this in C2
Then copy B2 and C2 down as far as the data. Easy way is when they are selected is to move the cursor to lower right corner and when it turns to black lines, double-click. It will automatically fill to however many cells are filled in Column A.