string concatenation

C

CaptainHook

Can I somehow name the string in A1 as, say, "001"
and the string in B1 as "002"
and make a formula in C1 like this: ="001"& "002"
I guess what I am trying to do is **not** to associate
a cell location with its content; instead, the string in a cell
to some globally defined name.

Is there a way in Excel we you can define a bunch of global
constants, like pi, x, y, z, etc. ? (they do not have to be in cells,
though it would be nice
 
T

tjtjjtjt

You need to hit Reply instead of starting a new thread every time--it's too
har to figure out what you are talking about when the information is spread
all over the place. Find your old post. It's beneath a post about "Map"
Button.
Someone tried to get more information from you there. Click on that person's
response and hit Reply instead of New.

tj
 
Top