View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default 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
&