View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raff Raff is offline
external usenet poster
 
Posts: 3
Default Merging data problem.

Hi everybody,
I have problem with data merging. I have 78 columns with data: 0 or 1.
I need have one number, for example: 100101011000... I've written
formula:=A1&B1&C1..., but: I see in result cell or text as formula, or
0. I checked format cells for text, number, general and nothings
changed. Do You know what am I doing wrong?
Best Regards
Raff