| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help to search a custom format
the column A1 has custom format 000-000 having the data like this
123-456 001-789 313-245 456-779 084-321 The column B1 has the following data ABC123456 DSD001789 HGH084321 YYY343434 like this 7500 record exist. I want to find column B1 value (numeric ) in Column A1. So ABC123456,DSD001789, HGH084321 exist in A1 . How I can search that numeric part in column A1. Pls help . Is there any function to give in formula bar. or Is it possible to write CTR+F, CTRL V to find automatcially in ceach cell. Please advice With thanks Pol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| auto filter doesn't return cells containing the custom search wor. | Excel Worksheet Functions | |||
Threaded Mode
