Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to select multiple text boxes in excel for formatting | New Users to Excel | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Formatting text box | Excel Discussion (Misc queries) | |||
How can I force certain text formatting in a cell? | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |