Thread: can we count words in a row which has links from other file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default can we count words in a row which has links from other file
=COUNTIF(E6:H6,"*WO*")

--
If this post helps click Yes
---------------
Jacob Skaria


"Vijay" wrote:

The data in workbook A is updated using formulas using the data in workbook
B. Can we count the specific words/letters in the row where the data is
imported in workbook A.

Example: Cells E 6- H6 in work book 'A' contains a formula which imports the
data from workbook 'B', i need to count the number of cells within E6 - H6
which contains the letter 'WO'.
Reply With QuoteReply With Quote