| 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 |
| 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 | |||
Threaded Mode
