when do use the & symbol in a text formula, how does it work
i am trying to learn the text formulas on excel and have video it used the
& in a formula along with quote marks and text not sure why and when to use & |
when do use the & symbol in a text formula, how does it work
e.g.
="First name: "&"Paul" ="Length of first name: "&LEN("Paul") etc. On 7 Maj, 15:09, paul cardarelli <paul wrote: i am trying to learn the text formulas on excel *and have video *it used the & in a formula along with quote marks and text * not sure why and when to use & |
when do use the & symbol in a text formula, how does it work
& is the alternate of CONCATENATE() function which is used to combine text
values.. A1 = Hi B1 = Paul C1 = CONCATENATE(a1," ",b1) The same can be achieved using C1 = A1 &" " & B -- If this post helps click Yes --------------- Jacob Skaria "paul cardarelli" wrote: i am trying to learn the text formulas on excel and have video it used the & in a formula along with quote marks and text not sure why and when to use & |
when do use the & symbol in a text formula, how does it work
The & symbol is the concatenate operator. It is used for joining two strings
together. -- HTH... Jim Thomlinson "paul cardarelli" wrote: i am trying to learn the text formulas on excel and have video it used the & in a formula along with quote marks and text not sure why and when to use & |
when do use the & symbol in a text formula, how does it work
Use the ampersand (&) to link one value to the next to form a continuous
string. For example, if cell A1 had the value of $50.00 and you wanted to concatenate a text prefix and suffix so it said "The Value of $50.00 is in cell A1." the formula would look like this. ="The Value of "&A1&" is in cell A1." Note that the literal spaces are always within the quotes, and the ampersand joining one value to the next does not have any spacing. Hope this helps. -- Kevin Backmann Dallas, TX "paul cardarelli" wrote: i am trying to learn the text formulas on excel and have video it used the & in a formula along with quote marks and text not sure why and when to use & |
All times are GMT +1. The time now is 08:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com