I have names like
frank steven louis
alex stewart
I want to move the last words of each column to a new column.i have the collections of 200 data. Help me
Thanks
I have names like
frank steven louis
alex stewart
I want to move the last words of each column to a new column.i have the collections of 200 data. Help me
Thanks
Assuming that you have names in col. A and starts from A2, then try this code......
Is this what you want?Please Login or Register to view this content.
For detail see the attached sheet.
Last edited by sktneer; 05-08-2014 at 09:31 PM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
You should be able to achieve this using the following Formulae.
Suppose Full names is in Column A, Cell A1 onwards; and you want the last word in Column B, Cell B1 onwards, and the everything before it in Column C, Cell C1 onwards, then:
in cell B1, use
Formula:Please Login or Register to view this content.
in cell C1 use
Formula:Please Login or Register to view this content.
Then simply select Cell B1:C1, and drag down. Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks