How to change order of First and Last name

If you want to change the order of First name and last name then follow the steps. Let us assume there is a list containing the following names

nifty forum

tron legacy review

glee x factor

college football bowl games

playstation phone

ballon d or

djokovic

manoj tiwari

jerry kill

michael jackson new album

moil allotment

mirapakaya songs

mirapakaya songs free download

chennai rain

anil ambani house

jkbose

bhel ranipet

jkbose results

ambedkar jayanti

shark egypt

----------------------------------------

Now you have to bring the last part of these names to the first position. Follow the steps for it.

First copy the names into another new word document

Select the names and convert text to Table. Use ‘space’ as separator.

The result will be a table having each part of the name in a cell. Copy the complete table and paste it in MS Excel.

Now in excel, copy the right-most column and paste it in another worksheet at left.

Copy the other columns and paste them in order as you want. As I done, I got the names in fully reverse order. Some left cells will be empty.

Now again copy the reversed names from Excel and paste in in Word. It will show as a table.

		forum	nifty
	review	legacy	tron
	factor	x	glee
games	bowl	football	college
		phone	playstation
	or	d	ballon
			djokovic
		tiwari	manoj
		kill	jerry
album	new	jackson	michael
		allotment	moil
		songs	mirapakaya
download	free	songs	mirapakaya
		rain	chennai
	house	ambani	anil
			jkbose
		ranipet	bhel
		results	jkbose
		jayanti	ambedkar
		egypt	shark

Now convert the table to text. Use ‘space’ as separator. It will be like this, having some ‘space’ in left side.

---------------------------------

    forum nifty

  review legacy tron

  factor x glee

games bowl football college

    phone playstation

  or d ballon

      djokovic

    tiwari manoj

    kill jerry

album new jackson  michael

    allotment moil

    songs mirapakaya

download free songs mirapakaya

    rain chennai

  house ambani anil

      jkbose

    ranipet bhel

    results jkbose

    jayanti ambedkar

    egypt  shark

-------------------------------

Now use the Find and Replace method. Type “^p ” (^p and space) in find what box and type “^p’’ in replace with box. Click the replace all button ten times or more.

Now put “  “ (double space) in find box and single space in replace box click ‘replace all’ until the replacement is 0.

Your work is done. Now just delete the spaces at the first line if any.

forum nifty

review legacy tron

factor x glee

games bowl football college

phone playstation

or d ballon

djokovic

tiwari manoj

kill jerry

album new jackson  michael

allotment moil

songs mirapakaya

download free songs mirapakaya

rain chennai

house ambani anil

jkbose

ranipet bhel

results jkbose

jayanti ambedkar

egypt  shark

For any further help, post your problem in comment.