| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text and number
i have something like this in a cell:
T2 T2 E1 T2 N3 can I add just the numbers and put the answer(10) in an adjacent cell and disregard the text? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and number
It might not be practical but how about using the text to columns facility.
Select the cell - data - text to columns - fixed width - next - place breaklines between text and numbers - next - finish (no need to format - general is OK) Now the data has been entered in consecutive cells which you may add. As I said it may not be practical - not knowing what other data is in your w/s. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Wade" wrote: i have something like this in a cell: T2 T2 E1 T2 N3 can I add just the numbers and put the answer(10) in an adjacent cell and disregard the text? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and number
that works - can i make it do that automatically to a cell?
thanks! wade "Russell Dawson" wrote: It might not be practical but how about using the text to columns facility. Select the cell - data - text to columns - fixed width - next - place breaklines between text and numbers - next - finish (no need to format - general is OK) Now the data has been entered in consecutive cells which you may add. As I said it may not be practical - not knowing what other data is in your w/s. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Wade" wrote: i have something like this in a cell: T2 T2 E1 T2 N3 can I add just the numbers and put the answer(10) in an adjacent cell and disregard the text? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Linear Mode
