Formula on TextBox

[Sahak]

Hi All,
To have text on “TextBox” we enter in formula bar, for example

=$A$1

and on TextBox we will get cell A1’s value.
Let say in A1 we have telephone # “(123) 456-7890” & we like to have on TextBox “Tel: (123) 456-7890”, It gives an error when we do as usually we do

=”Tel:“&$A$1

Thank you in advance

 

[Norie]

Try putting this formula in another cell, say B1 and then use =$B$1 in the formula bar.

=”Tel:“&$A$1

 

[Sahak]

Hi Norie,

Thank you very much, it works. So, it is not possible with one cell