| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing a list of names that have numbers- Can i take out the numb
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the numb
Assuming you have a long list of data such as this, and this data starts in
A2, in B2, type the following formula: B2: =SUBSTITUTE(A2,LEFT(A2,FIND(" ",A2)),"") Copy down as needed. If you want this change to be a 'permanent' change, highlight your data from B2 to B? (whatever), copy, then paste special value on top of itself. Delete column A. HTH. -- John C "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the numb
This should not be too hard. Assuming that all your data is in one column.
1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the SPACE option, press NEXT. 5: Press FINISH 6: Delete the unwanted column with the numbers. -- tech1NJ "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the numb
This should not be too hard. Assuming that all your data is in one column.
One more assumption... none of the text after the number/period/space have spaces in them; that is, you do NOT have an entries like these... 4. John Smith 5. Hanson, Roger Joseph Rick 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the SPACE option, press NEXT. 5: Press FINISH 6: Delete the unwanted column with the numbers. -- tech1NJ "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the
The fix depends on the character variation that you have. Will be possible
for you to place a good sample of the data you have indicating the different data you are dealing with? This will help us help you. Thanks -- tech1NJ "Rick Rothstein (MVP - VB)" wrote: This should not be too hard. Assuming that all your data is in one column. One more assumption... none of the text after the number/period/space have spaces in them; that is, you do NOT have an entries like these... 4. John Smith 5. Hanson, Roger Joseph Rick 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the SPACE option, press NEXT. 5: Press FINISH 6: Delete the unwanted column with the numbers. -- tech1NJ "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the
You probably should have posted your message against the OP's original
posting rather than mine... he may not see it here. Rick "tech1NJ" wrote in message ... The fix depends on the character variation that you have. Will be possible for you to place a good sample of the data you have indicating the different data you are dealing with? This will help us help you. Thanks -- tech1NJ "Rick Rothstein (MVP - VB)" wrote: This should not be too hard. Assuming that all your data is in one column. One more assumption... none of the text after the number/period/space have spaces in them; that is, you do NOT have an entries like these... 4. John Smith 5. Hanson, Roger Joseph Rick 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the SPACE option, press NEXT. 5: Press FINISH 6: Delete the unwanted column with the numbers. -- tech1NJ "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the
Will do thanks for the heads up.
-- tech1NJ "Rick Rothstein (MVP - VB)" wrote: You probably should have posted your message against the OP's original posting rather than mine... he may not see it here. Rick "tech1NJ" wrote in message ... The fix depends on the character variation that you have. Will be possible for you to place a good sample of the data you have indicating the different data you are dealing with? This will help us help you. Thanks -- tech1NJ "Rick Rothstein (MVP - VB)" wrote: This should not be too hard. Assuming that all your data is in one column. One more assumption... none of the text after the number/period/space have spaces in them; that is, you do NOT have an entries like these... 4. John Smith 5. Hanson, Roger Joseph Rick 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the SPACE option, press NEXT. 5: Press FINISH 6: Delete the unwanted column with the numbers. -- tech1NJ "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Editing a list of names that have numbers- Can i take out the numb
The fix depends on the character variations that you have. Will it be
possible for you to place a good sample of the data you have indicating the different data you are dealing with? This will help us help you. Thanks -- tech1NJ "WalMatt23" wrote: I have a bunch of data in a spreadsheet that has lists of names such as 1. Smith 2. Hanson 3. Rodriguez is there a command or series of commands to edit this column of data to remove the number, the period, and the space before the beginning of each name? Thanks in Advance Matt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a list of discrete numbers (names?) and occurences of each | New Users to Excel | |||
| Matching numbers in an Array and returning values for matched numb | Excel Discussion (Misc queries) | |||
| How do I sum up only the numbers in cells containing text and numb | Excel Discussion (Misc queries) | |||
| How can I change a list of phone numbers into peoples names | New Users to Excel | |||
| How 2 separate column of addresses into a colum of names and numb | Excel Discussion (Misc queries) | |||
Hybrid Mode
