Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to extract numbers from a string of text. For example, the data
I have a AMHERST /IN: CK 623 CASA NINOS OF MONT/IN: CK 8996 MONT SCH OF MANHA REF:954 MONT SCH OF DOWNT REF:10136 THE MIAMI MONT SC REF:1070 RESTON MONT SCH REF:13926 DAKOTA MONT SCH REF:15069 What I want to extract is the following: If there is a "CK" (check #), I want the number value in one column. If there is a "REF:", I want the number value in another column. As shown above, the numbers can be of varying length. Can someone tell me how I can do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting a word from a text string | Excel Discussion (Misc queries) | |||
Extracting text from text string | Excel Worksheet Functions | |||
extracting numbers from variable text | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
extracting data from a text string of varying length | Excel Discussion (Misc queries) |