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

[ashish koul]

See if it helps


On Fri, Aug 26, 2011 at 7:37 PM, GreenBriar wrote:

> 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 spaces instead of a space of hyphen, I
> can fix this in find and replace if needed)
>
> John Smith M
> Alex Smith
> Mary Jones
> Greg JacksonHarris P
> Brenda DiazGarcia Maria T
>
> Thanks you for any help.
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


SAMPLE TEST.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[GreenBriar]

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 spaces instead of a space of hyphen, I
can fix this in find and replace if needed)

John Smith M
Alex Smith
Mary Jones
Greg JacksonHarris P
Brenda DiazGarcia Maria T

Thanks you for any help.



-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel