Rename Users by excel Sheet

Hello,

I have a list of username for our employee in my organization. Some of them with First.last  and some of them with last + first initial. I.e: First.last & LastF.

I want to rename the users with First.Last to be Last+ first initial.

First i want to prepare the excel sheet with a column to take the user First.Last and rename it for Last+F.

How i can do it on excell.

Please help.
LVL 2
fadyazAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
You would have to save the file as CSV or TXT. I don't think you can rename directly from Excel (.XLS).

Here is some further information to help you.

https://social.technet.microsoft.com/Forums/scriptcenter/en-US/08d91b00-3035-4ce7-b062-25035bf01ad8/rename-user-accounts-in-ad-from-file-eg-csv?forum=ITCG
NVITEnd-user supportCommented:
Would you like to rename names in an existing excel file or rename the account username in active directory?
fadyazAuthor Commented:
I want the functional accounts on the excell sheet it self then later i will import it to active directory.
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

NVITEnd-user supportCommented:
Put formula in B1.
=IF((IFERROR(FIND(".",$A1),$A1) =$A1),$A1,MID($A1,FIND(".",$A1)+1,50)&LEFT($A1,1))

Open in new window


Example:

A1                    B1
First.Last            LastF
LastF	              LastF
John.Hopkins	      HopkinsJ

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
That can be simplified to have the FIND applied only once:
=IFERROR(MID($A1,FIND(".",$A1)+1,50)&LEFT($A1,1),$A1)

Open in new window

Eng. Nidal KamalInformation ConsultantCommented:
Good day,

After using any of the two formulas, mentioned above, in the new column, One has to drag the cell that wrote the formula on, from the right bottom corner, to rest of all needed cells.

Or select the formula cell and all underneath , then click on Fill and choose Down, attached.

Or pick the formula cell, then click on Shift and Down arrow, to select  needed cells. Then press on Ctrl + D keys on keyboard, to rearrange all needed names, in the new column.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
Aside of using macro or formula, if your data in Excel got a similar pattern (let's say delimiter), then you probably can use existing Excel function to split your data, and then to join them back to the text you want when necessary.

just see which approach is best suit your need.

Split names by using the Convert Text to Columns Wizard
https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-2cd989db-2b1f-4d89-b17b-534250ff9905

Text to Columns
http://www.excel-easy.com/examples/text-to-columns.html
fadyazAuthor Commented:
Will check now and update you soon
fadyazAuthor Commented:
Thanks for your help
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You are not providing points for the improvement in http:#a41166864, which makes the formula much better to read?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.