Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the number from text?
I have data as this format: 025BNN, 033WGN, I want to get only the numbers
from the text. how can i do that? thx. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the number from text?
Get them how (what format)? Put them where (same cell, different cells)?
-- Rick (MVP - Excel) "JJ" wrote in message ... I have data as this format: 025BNN, 033WGN, I want to get only the numbers from the text. how can i do that? thx. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the number from text?
if all your data are in this format with the first 3 characters being 'number'
use =LEFT(A2,3) this assume data start at row 2. HTH -- Pls provide your feedback by clicking the Yes button below if this post have help you. This will help others to search the archives for result better. Thank You cheers, francis "JJ" wrote: I have data as this format: 025BNN, 033WGN, I want to get only the numbers from the text. how can i do that? thx. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the number from text?
Hi
And assuming you want them as number and that they are always 3 number followed by any number of things: =--LEFT(A1,3) If there can be any number of number before the text then: =LOOKUP(9^9,--MID(D9,1,ROW(INDIRECT("1:"&LEN(D9))))) Note that both of these return number not text numbers. -- If this helps, please click the Yes button Cheers, Shane Devenshire "JJ" wrote: I have data as this format: 025BNN, 033WGN, I want to get only the numbers from the text. how can i do that? thx. |
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 |