Formulas dealing with text data

There are hundreds of examples in the Excel newsgroups

Here's a link to facilitate searching the Excel NGs

http://groups.google.com/advanced_gr..._ugroup=*excel


"Bagia" wrote:

> Hello,
>
> Does anyone know where I can find formulas that deal with text data, for
> example countif? Any help would be appreciated.
>
> Thanks!

Duke...thanks for your suggestion. I tried to enter "formulas dealing with
text data" and only one came up...mine and yours. Is there a way to search
so that only formulas that deal with text data will appear?



"Duke Carey" wrote:

> There are hundreds of examples in the Excel newsgroups
>
> Here's a link to facilitate searching the Excel NGs
>
> http://groups.google.com/advanced_gr..._ugroup=*excel
>
>
> "Bagia" wrote:
>
> > Hello,
> >
> > Does anyone know where I can find formulas that deal with text data, for
> > example countif? Any help would be appreciated.
> >
> > Thanks!

As an example, I used your comment about COUNTIF and text values. The search
string was "countif text values" Lots of good results

"Bagia" wrote:

> Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> text data" and only one came up...mine and yours. Is there a way to search
> so that only formulas that deal with text data will appear?
>
>
>
> "Duke Carey" wrote:
>
> > There are hundreds of examples in the Excel newsgroups
> >
> > Here's a link to facilitate searching the Excel NGs
> >
> > http://groups.google.com/advanced_gr..._ugroup=*excel
> >
> >
> > "Bagia" wrote:
> >
> > > Hello,
> > >
> > > Does anyone know where I can find formulas that deal with text data, for
> > > example countif? Any help would be appreciated.
> > >
> > > Thanks!

Thanks Duke. I don't use text data, but my students do. They want to learn
more about formulas that deal with text and I have no clue except for
countif. Any suggestions?

Thanks so much for your help.

"Duke Carey" wrote:

> As an example, I used your comment about COUNTIF and text values. The search
> string was "countif text values" Lots of good results
>
> "Bagia" wrote:
>
> > Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> > text data" and only one came up...mine and yours. Is there a way to search
> > so that only formulas that deal with text data will appear?
> >
> >
> >
> > "Duke Carey" wrote:
> >
> > > There are hundreds of examples in the Excel newsgroups
> > >
> > > Here's a link to facilitate searching the Excel NGs
> > >
> > > http://groups.google.com/advanced_gr..._ugroup=*excel
> > >
> > >
> > > "Bagia" wrote:
> > >
> > > > Hello,
> > > >
> > > > Does anyone know where I can find formulas that deal with text data, for
> > > > example countif? Any help would be appreciated.
> > > >
> > > > Thanks!

From Excel's help file, under Text and Data Functions:

Text and Data functions
ASC Changes full-width (double-byte) English letters or katakana within a
character string to half-width (single-byte) characters

BAHTTEXT Converts a number to text, using the ß (baht) currency format

CHAR Returns the character specified by the code number

CLEAN Removes all nonprintable characters from text

CODE Returns a numeric code for the first character in a text string

CONCATENATE Joins several text items into one text item

DOLLAR Converts a number to text, using the $ (dollar) currency format

EXACT Checks to see if two text values are identical

FIND Finds one text value within another (case-sensitive)

FIXED Formats a number as text with a fixed number of decimals

JIS Changes half-width (single-byte) English letters or katakana within a
character string to full-width (double-byte) characters

LEFT Returns the leftmost characters from a text value

LEN Returns the number of characters in a text string

LOWER Converts text to lowercase

MID Returns a specific number of characters from a text string starting at
the position you specify

PHONETIC Extracts the phonetic (furigana) characters from a text string

PROPER Capitalizes the first letter in each word of a text value

REPLACE Replaces characters within text

REPT Repeats text a given number of times

RIGHT Returns the rightmost characters from a text value

SEARCH Finds one text value within another (not case-sensitive)

SUBSTITUTE Substitutes new text for old text in a text string

T Converts its arguments to text

TEXT Formats a number and converts it to text

TRIM Removes spaces from text

UPPER Converts text to uppercase

VALUE Converts a text argument to a number


"Bagia" wrote:

> Thanks Duke. I don't use text data, but my students do. They want to learn
> more about formulas that deal with text and I have no clue except for
> countif. Any suggestions?
>
> Thanks so much for your help.
>
> "Duke Carey" wrote:
>
> > As an example, I used your comment about COUNTIF and text values. The search
> > string was "countif text values" Lots of good results
> >
> > "Bagia" wrote:
> >
> > > Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> > > text data" and only one came up...mine and yours. Is there a way to search
> > > so that only formulas that deal with text data will appear?
> > >
> > >
> > >
> > > "Duke Carey" wrote:
> > >
> > > > There are hundreds of examples in the Excel newsgroups
> > > >
> > > > Here's a link to facilitate searching the Excel NGs
> > > >
> > > > http://groups.google.com/advanced_gr..._ugroup=*excel
> > > >
> > > >
> > > > "Bagia" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > Does anyone know where I can find formulas that deal with text data, for
> > > > > example countif? Any help would be appreciated.
> > > > >
> > > > > Thanks!

Thanks Duke! That's exactly what I did. Thank you again.

"Duke Carey" wrote:

> From Excel's help file, under Text and Data Functions:
>
> Text and Data functions
> ASC Changes full-width (double-byte) English letters or katakana within a
> character string to half-width (single-byte) characters
>
> BAHTTEXT Converts a number to text, using the ß (baht) currency format
>
> CHAR Returns the character specified by the code number
>
> CLEAN Removes all nonprintable characters from text
>
> CODE Returns a numeric code for the first character in a text string
>
> CONCATENATE Joins several text items into one text item
>
> DOLLAR Converts a number to text, using the $ (dollar) currency format
>
> EXACT Checks to see if two text values are identical
>
> FIND Finds one text value within another (case-sensitive)
>
> FIXED Formats a number as text with a fixed number of decimals
>
> JIS Changes half-width (single-byte) English letters or katakana within a
> character string to full-width (double-byte) characters
>
> LEFT Returns the leftmost characters from a text value
>
> LEN Returns the number of characters in a text string
>
> LOWER Converts text to lowercase
>
> MID Returns a specific number of characters from a text string starting at
> the position you specify
>
> PHONETIC Extracts the phonetic (furigana) characters from a text string
>
> PROPER Capitalizes the first letter in each word of a text value
>
> REPLACE Replaces characters within text
>
> REPT Repeats text a given number of times
>
> RIGHT Returns the rightmost characters from a text value
>
> SEARCH Finds one text value within another (not case-sensitive)
>
> SUBSTITUTE Substitutes new text for old text in a text string
>
> T Converts its arguments to text
>
> TEXT Formats a number and converts it to text
>
> TRIM Removes spaces from text
>
> UPPER Converts text to uppercase
>
> VALUE Converts a text argument to a number
>
>
> "Bagia" wrote:
>
> > Thanks Duke. I don't use text data, but my students do. They want to learn
> > more about formulas that deal with text and I have no clue except for
> > countif. Any suggestions?
> >
> > Thanks so much for your help.
> >
> > "Duke Carey" wrote:
> >
> > > As an example, I used your comment about COUNTIF and text values. The search
> > > string was "countif text values" Lots of good results
> > >
> > > "Bagia" wrote:
> > >
> > > > Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> > > > text data" and only one came up...mine and yours. Is there a way to search
> > > > so that only formulas that deal with text data will appear?
> > > >
> > > >
> > > >
> > > > "Duke Carey" wrote:
> > > >
> > > > > There are hundreds of examples in the Excel newsgroups
> > > > >
> > > > > Here's a link to facilitate searching the Excel NGs
> > > > >
> > > > > http://groups.google.com/advanced_gr..._ugroup=*excel
> > > > >
> > > > >
> > > > > "Bagia" wrote:
> > > > >
> > > > > > Hello,
> > > > > >
> > > > > > Does anyone know where I can find formulas that deal with text data, for
> > > > > > example countif? Any help would be appreciated.
> > > > > >
> > > > > > Thanks!

Hello,

Does anyone know where I can find formulas that deal with text data, for
example countif? Any help would be appreciated.

Thanks!

There are hundreds of examples in the Excel newsgroups

Here's a link to facilitate searching the Excel NGs

http://groups.google.com/advanced_gr..._ugroup=*excel


"Bagia" wrote:

> Hello,
>
> Does anyone know where I can find formulas that deal with text data, for
> example countif? Any help would be appreciated.
>
> Thanks!

Duke...thanks for your suggestion. I tried to enter "formulas dealing with
text data" and only one came up...mine and yours. Is there a way to search
so that only formulas that deal with text data will appear?



"Duke Carey" wrote:

> There are hundreds of examples in the Excel newsgroups
>
> Here's a link to facilitate searching the Excel NGs
>
> http://groups.google.com/advanced_gr..._ugroup=*excel
>
>
> "Bagia" wrote:
>
> > Hello,
> >
> > Does anyone know where I can find formulas that deal with text data, for
> > example countif? Any help would be appreciated.
> >
> > Thanks!

As an example, I used your comment about COUNTIF and text values. The search
string was "countif text values" Lots of good results

"Bagia" wrote:

> Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> text data" and only one came up...mine and yours. Is there a way to search
> so that only formulas that deal with text data will appear?
>
>
>
> "Duke Carey" wrote:
>
> > There are hundreds of examples in the Excel newsgroups
> >
> > Here's a link to facilitate searching the Excel NGs
> >
> > http://groups.google.com/advanced_gr..._ugroup=*excel
> >
> >
> > "Bagia" wrote:
> >
> > > Hello,
> > >
> > > Does anyone know where I can find formulas that deal with text data, for
> > > example countif? Any help would be appreciated.
> > >
> > > Thanks!

Thanks Duke. I don't use text data, but my students do. They want to learn
more about formulas that deal with text and I have no clue except for
countif. Any suggestions?

Thanks so much for your help.

"Duke Carey" wrote:

> As an example, I used your comment about COUNTIF and text values. The search
> string was "countif text values" Lots of good results
>
> "Bagia" wrote:
>
> > Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> > text data" and only one came up...mine and yours. Is there a way to search
> > so that only formulas that deal with text data will appear?
> >
> >
> >
> > "Duke Carey" wrote:
> >
> > > There are hundreds of examples in the Excel newsgroups
> > >
> > > Here's a link to facilitate searching the Excel NGs
> > >
> > > http://groups.google.com/advanced_gr..._ugroup=*excel
> > >
> > >
> > > "Bagia" wrote:
> > >
> > > > Hello,
> > > >
> > > > Does anyone know where I can find formulas that deal with text data, for
> > > > example countif? Any help would be appreciated.
> > > >
> > > > Thanks!

From Excel's help file, under Text and Data Functions:

Text and Data functions
ASC Changes full-width (double-byte) English letters or katakana within a
character string to half-width (single-byte) characters

BAHTTEXT Converts a number to text, using the ß (baht) currency format

CHAR Returns the character specified by the code number

CLEAN Removes all nonprintable characters from text

CODE Returns a numeric code for the first character in a text string

CONCATENATE Joins several text items into one text item

DOLLAR Converts a number to text, using the $ (dollar) currency format

EXACT Checks to see if two text values are identical

FIND Finds one text value within another (case-sensitive)

FIXED Formats a number as text with a fixed number of decimals

JIS Changes half-width (single-byte) English letters or katakana within a
character string to full-width (double-byte) characters

LEFT Returns the leftmost characters from a text value

LEN Returns the number of characters in a text string

LOWER Converts text to lowercase

MID Returns a specific number of characters from a text string starting at
the position you specify

PHONETIC Extracts the phonetic (furigana) characters from a text string

PROPER Capitalizes the first letter in each word of a text value

REPLACE Replaces characters within text

REPT Repeats text a given number of times

RIGHT Returns the rightmost characters from a text value

SEARCH Finds one text value within another (not case-sensitive)

SUBSTITUTE Substitutes new text for old text in a text string

T Converts its arguments to text

TEXT Formats a number and converts it to text

TRIM Removes spaces from text

UPPER Converts text to uppercase

VALUE Converts a text argument to a number


"Bagia" wrote:

> Thanks Duke. I don't use text data, but my students do. They want to learn
> more about formulas that deal with text and I have no clue except for
> countif. Any suggestions?
>
> Thanks so much for your help.
>
> "Duke Carey" wrote:
>
> > As an example, I used your comment about COUNTIF and text values. The search
> > string was "countif text values" Lots of good results
> >
> > "Bagia" wrote:
> >
> > > Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> > > text data" and only one came up...mine and yours. Is there a way to search
> > > so that only formulas that deal with text data will appear?
> > >
> > >
> > >
> > > "Duke Carey" wrote:
> > >
> > > > There are hundreds of examples in the Excel newsgroups
> > > >
> > > > Here's a link to facilitate searching the Excel NGs
> > > >
> > > > http://groups.google.com/advanced_gr..._ugroup=*excel
> > > >
> > > >
> > > > "Bagia" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > Does anyone know where I can find formulas that deal with text data, for
> > > > > example countif? Any help would be appreciated.
> > > > >
> > > > > Thanks!

Thanks Duke! That's exactly what I did. Thank you again.

"Duke Carey" wrote:

> From Excel's help file, under Text and Data Functions:
>
> Text and Data functions
> ASC Changes full-width (double-byte) English letters or katakana within a
> character string to half-width (single-byte) characters
>
> BAHTTEXT Converts a number to text, using the ß (baht) currency format
>
> CHAR Returns the character specified by the code number
>
> CLEAN Removes all nonprintable characters from text
>
> CODE Returns a numeric code for the first character in a text string
>
> CONCATENATE Joins several text items into one text item
>
> DOLLAR Converts a number to text, using the $ (dollar) currency format
>
> EXACT Checks to see if two text values are identical
>
> FIND Finds one text value within another (case-sensitive)
>
> FIXED Formats a number as text with a fixed number of decimals
>
> JIS Changes half-width (single-byte) English letters or katakana within a
> character string to full-width (double-byte) characters
>
> LEFT Returns the leftmost characters from a text value
>
> LEN Returns the number of characters in a text string
>
> LOWER Converts text to lowercase
>
> MID Returns a specific number of characters from a text string starting at
> the position you specify
>
> PHONETIC Extracts the phonetic (furigana) characters from a text string
>
> PROPER Capitalizes the first letter in each word of a text value
>
> REPLACE Replaces characters within text
>
> REPT Repeats text a given number of times
>
> RIGHT Returns the rightmost characters from a text value
>
> SEARCH Finds one text value within another (not case-sensitive)
>
> SUBSTITUTE Substitutes new text for old text in a text string
>
> T Converts its arguments to text
>
> TEXT Formats a number and converts it to text
>
> TRIM Removes spaces from text
>
> UPPER Converts text to uppercase
>
> VALUE Converts a text argument to a number
>
>
> "Bagia" wrote:
>
> > Thanks Duke. I don't use text data, but my students do. They want to learn
> > more about formulas that deal with text and I have no clue except for
> > countif. Any suggestions?
> >
> > Thanks so much for your help.
> >
> > "Duke Carey" wrote:
> >
> > > As an example, I used your comment about COUNTIF and text values. The search
> > > string was "countif text values" Lots of good results
> > >
> > > "Bagia" wrote:
> > >
> > > > Duke...thanks for your suggestion. I tried to enter "formulas dealing with
> > > > text data" and only one came up...mine and yours. Is there a way to search
> > > > so that only formulas that deal with text data will appear?
> > > >
> > > >
> > > >
> > > > "Duke Carey" wrote:
> > > >
> > > > > There are hundreds of examples in the Excel newsgroups
> > > > >
> > > > > Here's a link to facilitate searching the Excel NGs
> > > > >
> > > > > http://groups.google.com/advanced_gr..._ugroup=*excel
> > > > >
> > > > >
> > > > > "Bagia" wrote:
> > > > >
> > > > > > Hello,
> > > > > >
> > > > > > Does anyone know where I can find formulas that deal with text data, for
> > > > > > example countif? Any help would be appreciated.
> > > > > >
> > > > > > Thanks!