Re: $$Excel-Macros$$ Finding text within data

2013-07-14 Thread De Premor
PFA On 09/07/2013 1:43, ha...@mst.edu wrote: Hi All, Basically, I want to find a text from specific category and return the text/number to a specific cell. For example, API NUMBER: (return the value here) Find API number from the following text(be aware:API # is always 10 numbers separated by

Re: $$Excel-Macros$$ Finding text within data

2013-07-09 Thread ashish koul
can u share the sample file On Tue, Jul 9, 2013 at 12:13 AM, wrote: > Hi All, > Basically, I want to find a text from specific category and return the > text/number to a specific cell. > For example, > API NUMBER: (return the value here) > Find API number from the following text(be aware:API #

$$Excel-Macros$$ Finding text within data

2013-07-08 Thread harh2
Hi All, Basically, I want to find a text from specific category and return the text/number to a specific cell. For example, API NUMBER: (return the value here) Find API number from the following text(be aware:API # is always 10 numbers separated by dashes e.g. nn-nnn-n) -