Adjust Code - Switch Last Name and First Name

A

Anthony G.

Active Member
Joined
Mar 24, 2002
Messages
465
Hello to All

I came across this piece of code that does a fine job of switching "LastName, FirstName" to "FirstName LastName" however, I can't figure out how to remove the comma...

Any suggestions?

Thanks...Anthony
Book1
ABCD
1Name
2Smith,JohnJohnSmith,
Sheet1
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

M
  • Question Question
Hyperlink Formula
Replies
2
Views
979
Mplz
M
J
  • Question Question
Excel VBA Print Name Tag from Userform
Replies
2
Views
402
Rhodie72
Rhodie72
B
  • Question Question
VBA Code to add a sheet after another errors out...
Replies
6
Views
1K
Alex Blakenburg
A
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
603
Mavericx
M
R
  • Solved
Avoid Repetition/Mismatch in TEXTJOIN of Cell Contents and a Named Range
2
Replies
11
Views
215
Fluff
Fluff

Forum statistics

Threads
1,225,477
Messages
6,185,210
Members
453,283
Latest member
Shortm88

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