| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
jackh
I have an excel spreadsheet with over 2000 surnames with initials in the same column as listed below eg John , N Jack , H Peter , S Ken , G How do I remove only the comma(,) after the surname in each row leaving only the surname with the initials ie John N Jack H - etc -- jackh |
|
#2
|
|||
|
|||
|
jackh Wrote: I have an excel spreadsheet with over 2000 surnames with initials in the same column as listed below eg John , N Jack , H Peter , S Ken , G How do I remove only the comma(,) after the surname in each row leaving only the surname with the initials ie John N Jack H - etc If the name is in A2 then put this formula in the cell you want the new name: =LEFT(A2,SEARCH(",",A2)-1) & RIGHT(A2,2) -- jahoobob |
|
#3
|
|||
|
|||
|
jackh Wrote: I have an excel spreadsheet with over 2000 surnames with initials in the same column as listed below eg John , N Jack , H Peter , S Ken , G How do I remove only the comma(,) after the surname in each row leaving only the surname with the initials ie John N Jack H - etc Jackh Just type "CTL H" (Or EditReplace) put a comma in the find field and nothing in the replace with field. that should do it. Odie -- Odicus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
