View Single Post
  #17   Report Post  
Max
 
Posts: n/a
Default

What's this symbol in front of the &B2 and what does it do -
?&B2?


Just a few words on Biff's behalf <g, but do hang around awhile for his
response

Using the ampersand "&" is equivalent to using the function CONCATENATE,
except that it's much shorter to type <g

Example: Putting in C2: = A2&" "&B2
will return "Buck Rogers"
if A2 contains: "Buck", B2 contains: "Rogers"

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----