| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
Hi Gary
in an adjacent column use the formula =SUBSTITUTE(RIGHT(A1,LEN(A1)-SEARCH(" ",A1))," ","") where A1 is the first cell containing the sports players and their numbers the fill down the column. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Gary H" wrote in message . .. 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 |
|
#3
|
|||
|
|||
|
Hi Julie, hope all is well!
As always, thanks for the help, it's greatly appreciated! Have a great day! Gary "JulieD" wrote in message ... Hi Gary in an adjacent column use the formula =SUBSTITUTE(RIGHT(A1,LEN(A1)-SEARCH(" ",A1))," ","") where A1 is the first cell containing the sports players and their numbers the fill down the column. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Gary H" wrote in message . .. 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 |
|
#4
|
|||
|
|||
|
you're welcome ... sounds like you've got yourself another project :)
-- "Gary H" wrote in message . .. Hi Julie, hope all is well! As always, thanks for the help, it's greatly appreciated! Have a great day! Gary "JulieD" wrote in message ... Hi Gary in an adjacent column use the formula =SUBSTITUTE(RIGHT(A1,LEN(A1)-SEARCH(" ",A1))," ","") where A1 is the first cell containing the sports players and their numbers the fill down the column. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Gary H" wrote in message . .. 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
