View Single Post
  #1   Report Post  
Gary H
 
Posts: n/a
Default Help formatting text

Hey all, I'm running Excel 2000, and would like to know how to do
something...

Basically I have a list of sports players and their number, formatted like
this..

20 Firstname Lastname
9 Firstname Lastname

Somehow I need to take the number out all together, and then I need to
concatenate the firstname with the lastname, so it's formatted as:

FirstnameLastname

Any help would be much appreciated! Thanks.

Gary