LOGICAL FUNCTIONS

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="post-body entry-content" id="post-body-4297374710954606778" style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 18.2px; padding: 14.2969px; text-align: justify;"><div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8-yPkiEnoSNn1bjd9iSVUiSNrC8mI1wIphPSARg-RpKOd_7f5nbWR98TDKvHIUMJ3b8txdKcmG5jwrcecSVz8w0vTd41fS79zSnMKaHYNbqMgiosA6ULwVXDBMYl2qG4iGtjw9GRnNVIE/s1600/Zbo55.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="http://gulpatutorial.blogspot.in/" border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8-yPkiEnoSNn1bjd9iSVUiSNrC8mI1wIphPSARg-RpKOd_7f5nbWR98TDKvHIUMJ3b8txdKcmG5jwrcecSVz8w0vTd41fS79zSnMKaHYNbqMgiosA6ULwVXDBMYl2qG4iGtjw9GRnNVIE/s200/Zbo55.png" title="http://gulpatutorial.blogspot.in/" width="200" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8-yPkiEnoSNn1bjd9iSVUiSNrC8mI1wIphPSARg-RpKOd_7f5nbWR98TDKvHIUMJ3b8txdKcmG5jwrcecSVz8w0vTd41fS79zSnMKaHYNbqMgiosA6ULwVXDBMYl2qG4iGtjw9GRnNVIE/s1600/Zbo55.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="color: #666666; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; text-align: justify;">Learn how to use</span><span style="color: #666666; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; text-align: justify;"> </span><span style="border: 0px; box-sizing: border-box; color: #666666; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">Excel's logical functions</span><span style="color: #666666; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; text-align: justify;"> </span><span style="color: #666666; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; text-align: justify;">such as the IF, AND and OR function.</span><span style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 12px; text-align: left;"> </span></a></div><div style="background-color: white; border: 0px; box-sizing: border-box; clear: both; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-stretch: inherit; line-height: 12px; margin: 0px; padding: 0px; vertical-align: baseline;"><br /></div><div class="entry" style="background-color: white; border: 0px; box-sizing: border-box; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-stretch: inherit; line-height: 12px; margin: 0px auto; padding: 0px 0px 20px; text-align: justify; vertical-align: baseline;"><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="if-function" name="if-function" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>If Function</h3><div><br /></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">The <span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">IF function</span> checks whether a condition is met, and returns one value if TRUE and another value if FALSE.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">1. Select cell C2 and enter the following function.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="If Function" src="http://www.excel-easy.com/functions/images/logical-functions/if-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="If Function" /></div><div class="ad" style="border: 0px; box-sizing: border-box; clear: both; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px 0px 10px; padding: 0px; vertical-align: baseline;"></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">The IF function returns Correct because the value in cell A1 is higher than 10.</div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="if-function2" name="and-function" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>And Function</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">The <span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AND Function</span> returns TRUE if all conditions are true and returns FALSE if any of the conditions are false.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">1. Select cell D2 and enter the following formula.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="And Function" src="http://www.excel-easy.com/functions/images/logical-functions/and-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="And Function" /></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">The AND function returns FALSE because the value in cell B2 is not higher than 5. As a result the IF function returns Incorrect.</div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="if-function3" name="or-function" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Or Function</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">The <span style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">OR function</span> returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">1. Select cell E2 and enter the following formula.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Or Function" src="http://www.excel-easy.com/functions/images/logical-functions/or-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Or Function" /></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">The OR function returns TRUE because the value in cell A1 is higher than 10. As a result the IF function returns Correct.</div></div></div></div></div>

LOGICAL FUNCTIONS

Learn how to use   Excel's logical functions   such as the IF, AND and OR function.   If Function The  IF function  checks whether a con...

Read More

TEXT FUNCTIONS in Excel

<div dir="ltr" style="text-align: left;" trbidi="on"><br /><div style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: left;"><img alt="http://gulpatutorial.blogspot.in/" border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-Z4k3QXEjfmSffSwy0WsK_oQbK6iWUdNox9IEGDJoE9OkGzyRXL2raFQkFNxEiyHRllVZXoSw-gHAvJbCYL_3l7amsEEitybpxMAqPYr1xzuOJ9XXXqXttA6ETDpSIP9z7djYyg9mxCgW/s200/Microsoft-Excel-2010-Logo+%25281%2529.jpg" title="http://gulpatutorial.blogspot.in/" width="200" /></div><div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><span id="goog_80603367"></span><span id="goog_80603368"></span><a href="https://www.blogger.com/"></a></div><br /><div class="topmeta" style="border: 1px solid rgb(241, 241, 241); color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 26px; padding: 7px 10px;"><span style="background-color: white; border: 0px; box-sizing: border-box; color: #666666; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><br /></span></div><div class="topmeta" style="border: 1px solid rgb(241, 241, 241); color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 26px; padding: 7px 10px;"><span style="background-color: white; border: 0px; box-sizing: border-box; color: #666666; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">Excel</span><span style="background-color: white; color: #666666; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; text-align: justify;"> has many functions to offer when it comes to manipulating </span><span style="background-color: white; border: 0px; box-sizing: border-box; color: #666666; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">text strings</span><span style="background-color: white; color: #666666; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; text-align: justify;">.</span><span class="fa fa-user-secret" style="-webkit-font-smoothing: antialiased; display: inline-block; font-family: FontAwesome; font-size: inherit; font-stretch: normal; line-height: 1; text-rendering: auto; transform: translate(0px, 0px);"></span></div><div class="post-body entry-content" id="post-body-7021517923531259180" style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 13px; line-height: 18.2px; padding: 14.2969px; text-align: justify;"><div dir="ltr" style="text-align: left;" trbidi="on"><div class="entry" style="background-color: white; border: 0px; box-sizing: border-box; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-stretch: inherit; line-height: 12px; margin: 0px auto; padding: 0px 0px 20px; text-align: justify; vertical-align: baseline;"><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="join-strings" name="join-strings" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Join Strings</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To join strings, use the & operator.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Join Strings" src="http://www.excel-easy.com/functions/images/text-functions/join-strings.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Join Strings" /></div><div class="ad" style="border: 0px; box-sizing: border-box; clear: both; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px 0px 10px; padding: 0px; vertical-align: baseline;"></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">Note: to insert a space, use " "</div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="left" name="left" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Left</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To extract the leftmost characters from a string, use the LEFT function.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Left Function" src="http://www.excel-easy.com/functions/images/text-functions/left-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Left Function" /></div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a><a href="https://www.blogger.com/null" id="right" name="right" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Right</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To extract the rightmost characters from a string, use the RIGHT function.<br /><a href="https://www.blogger.com/null" name="more"></a></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Right Function" src="http://www.excel-easy.com/functions/images/text-functions/right-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Right Function" /></div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="mid" name="mid" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Mid</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To extract a substring, starting in the middle of a string, use the MID function.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Mid Function" src="http://www.excel-easy.com/functions/images/text-functions/mid-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Mid Function" /></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">Note: started at position 5 (p) with length 3.</div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a><a href="https://www.blogger.com/null" id="len" name="len" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Len</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To get the length of a string, use the LEN function.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Len Function" src="http://www.excel-easy.com/functions/images/text-functions/len-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Len Function" /></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">Note: space (position 8) included!</div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a><a href="https://www.blogger.com/null" id="find" name="find" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Find</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To find the position of a substring in a string, use the FIND function.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Find Function" src="http://www.excel-easy.com/functions/images/text-functions/find-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Find Function" /></div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">Note: string "am" found at position 3.</div><h3 style="border: 0px; box-sizing: border-box; color: #3e3530; font-family: inherit; font-size: 1.6em; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: normal; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"><a href="https://www.blogger.com/null" id="substitute" name="substitute" style="border: 0px; box-sizing: border-box; color: #339ccb; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;"></a>Substitute</h3><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;">To replace existing text with new text in a string, use the SUBSTITUTE function.</div><div style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: 21.6px; margin-bottom: 10px; padding: 0px; vertical-align: baseline;"><img alt="Substitute Function" src="http://www.excel-easy.com/functions/images/text-functions/substitute-function.png" style="border: 0px; box-sizing: border-box; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; height: auto; line-height: inherit; margin: 0px; max-width: 100%; padding: 0px; vertical-align: baseline;" title="Substitute Function" /></div></div></div></div></div>

TEXT FUNCTIONS in Excel

Excel  has many functions to offer when it comes to manipulating  text strings . Join Strings To join strings, use the & operator. Note:...

Read More