Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas dealing with text data
Hello,
Does anyone know where I can find formulas that deal with text data, for example countif? Any help would be appreciated. Thanks! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
#6
|
|||
|
|||
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! |
#7
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting data without removing formulas | Excel Discussion (Misc queries) | |||
input text at front of field that contains data | Excel Discussion (Misc queries) | |||
I have 2 columns to compare,each text. doing formulas, they don'. | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |