Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Formula

Status
Not open for further replies.
njd3vil

njd3vil

Technical User
Aug 8, 2007
84
US
Greetings,

I have a column in excel that has a list of names in Last, First format. How can I swap Last and First and delete the comma?

Thanks!
 
Sort by date Sort by votes
but if you really want a formula:
=TRIM(RIGHT(A1, LEN(A1)-FIND(",", A1)) & " " & LEFT(A1, FIND(",", A1)-1))
 
Upvote 0 Downvote
Thank You!!!!! This just saved me hours of typing!!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
489
SkipVought
S
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
784
dhookom
dhookom
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
583
bs6600
bs6600
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
297
TomSalvato
TomSalvato
Swi
  • Question
Excel Webservice
Replies
2
Views
320
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top