Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy numbers from numbers+text cell
How do I copy only the numbers from a cell with numbers and text and symbols
to a new cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy numbers from numbers+text cell
Perhaps if you could post a few examples of what you have, someone
might be able to suggest a way to split the numbers out. Pete Henk wrote: How do I copy only the numbers from a cell with numbers and text and symbols to a new cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy numbers from numbers+text cell
Ok
I have this Check #275884 I need only 275884, how do I do so. Thanks Henk "Pete_UK" wrote: Perhaps if you could post a few examples of what you have, someone might be able to suggest a way to split the numbers out. Pete Henk wrote: How do I copy only the numbers from a cell with numbers and text and symbols to a new cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy numbers from numbers+text cell
if you have data in cell A1 then put in B1 =MID(A1,FIND("#",A1)+1,100) Henk Wrote: Ok I have this Check #275884 I need only 275884, how do I do so. Thanks Henk "Pete_UK" wrote: Perhaps if you could post a few examples of what you have, someone might be able to suggest a way to split the numbers out. Pete Henk wrote: How do I copy only the numbers from a cell with numbers and text and symbols to a new cell? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=570732 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
copy text to specific cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
excel - numbers as text | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |