Change name format

D

Deltab

New Member
Joined
Sep 27, 2017
Messages
1
I have large sheet of names in the format- Last Name, First Name. How can I change this to- First initial of First Name followed by period then Last Name-Thank you.
 
Last edited by a moderator:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

A
  • Question Question
How to extract first initial and last name from a cell with full name?
Replies
3
Views
213
Rick Rothstein
Rick Rothstein
M
  • Question Question
How to split a full name in 1 column into 2 columns (C1 - First name, C2 - Last name (*but here's the tricky - what if there's a middle initial?
Replies
6
Views
384
Mavericx
M
F
  • Question Question
Macro to copy the format of a chosen named range to another fixed point
2
Replies
10
Views
474
DanteAmor
DanteAmor
S
  • Question Question
Comparing Columns of names
Replies
5
Views
240
Zot
Z
L
  • Solved
Duplicate First and last name Question
Replies
3
Views
198
Joe4
Joe4

Forum statistics

Threads
1,223,907
Messages
6,175,301
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top