View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Traveller Traveller is offline
external usenet poster
 
Posts: 7
Default simply function not work

Try "=A3+B3" instead of "=A3&B3" (with a "+" instead of a "&"). The "&" joins
two text segement together.

"ViestaWu" wrote:

Dear all,

Today I have try to use function, but it doesn't work. The function I used
is quite simple: =A3 & B3. But the cell shows the function itself instead of
the result.

Besides, I have checked that tools=options=calculate, the "automatical"
one is checked.

Why the function still doesn't work? Could anybody show me the way?

Thanks,
Viesta