| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding a number within a text and numbers for multiple rows
i have the following text in
A1 Darshan_4875_09 A2 Jack_4888_09 A3 Johansson_8988_09 A4 AB_9900_09 I need to get in column B only the numbers i.e. B1 4875 B2 4888 B3 8988 B4 9900 How do i get this |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding a number within a text and numbers for multiple rows
=MID(A1,FIND("_",A1,1)+1,4) and copy down
-- Gary''s Student - gsnu200820 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding a number within a text and numbers for multiple rows
sorry i think i did not give the full picture.
my file has this A1 Darshan_RA_4878_09 A2 MA_RC_9900_09 A3 Johansson_AB_8800_09 A4 Mic_CC_8900_09 so i need to get in B1 (4878), B2 (9900), etc currently your formula is not working "Gary''s Student" wrote: =MID(A1,FIND("_",A1,1)+1,4) and copy down -- Gary''s Student - gsnu200820 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding a number within a text and numbers for multiple rows
=MID(A1,FIND("_",A1,FIND("_",A1,1)+1)+1,4)
-- Gary''s Student - gsnu200820 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
finding a number within a text and numbers for multiple rows
=MID(A1,FIND("_",A1,1)+1,4)
-- Gary''s Student - gsnu200820 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with finding numbers within text and summing | Excel Worksheet Functions | |||
| Finding matching numbers in different rows. | Excel Worksheet Functions | |||
| Finding the minimum in a selected number of rows of the same colum | Excel Worksheet Functions | |||
| finding the no. of rows in a COL filled with numbers, zeros and bl | Excel Worksheet Functions | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Hybrid Mode
