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 |