Need Excel help changing full name into first/last
There has got to be a quick way to do this, but I can't find it -
I've got columns of names that are the person's first name - a space - and their last name, and I need this in 2 columns - first name and last name -
Anyone know a macro or quick & dirty way to pull this off? - I've got close to 2000 names and don't have a desire to re-type them all.....
Found it -
Data - Text to Columns - delimited -
it parses out the name into seperate columns and did 98% of the work for me -
Had a column of names while had the first & last in the same field - had to split this out for a macro to run correctly.....
just had to figure out where to look....
Another one for the archives....
New Security Features Planned for Firefox 4
Another Laptop Theft Exposes 21K Patients' Data
Oracle Hits to Road to Pitch Data Center Plans
Microsoft Preps Array of Windows Patches
Microsoft Nears IE9 Beta With Final Preview
Simplified Analytics Improve CRM, BI Tools
Android Passes RIM as Top Mobile OS in 2Q
VMware Updates Hyperic System Management
File Monitoring Key to Enterprise Security
LinkedIn Snaps Up SaaS Player mSpoke