| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell with numbers and names, need to devide them
Hello,
I have list of names and digits from A1 to A100. It is shown as "PeeterXcrter 5696959594" I need to devide 1 cell thisway, that this number will go to B row. Thank you for help. Peter |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell with numbers and names, need to devide them
Hi,
Provided your data are as in the example below then try this in column B and drag down:- =MID(A1,FIND(" ",A1,1)+1,LEN(A1)) If you have more than 1 space in yor data then post back. Mike "Lion2004" wrote: Hello, I have list of names and digits from A1 to A100. It is shown as "PeeterXcrter 5696959594" I need to devide 1 cell thisway, that this number will go to B row. Thank you for help. Peter |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell with numbers and names, need to devide them
You may want to select the column and then use Data|Text to columns (xl2003 menu
system). Lion2004 wrote: Hello, I have list of names and digits from A1 to A100. It is shown as "PeeterXcrter 5696959594" I need to devide 1 cell thisway, that this number will go to B row. Thank you for help. Peter -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| names to numbers | Excel Discussion (Misc queries) | |||
| devide by 0 error | Excel Worksheet Functions | |||
| Assigning numbers to names | Excel Discussion (Misc queries) | |||
| how to print defined cell names with comments, not numbers? | New Users to Excel | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
