View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trekman Trekman is offline
external usenet poster
 
Posts: 11
Default How to get value a field based on of two other columns?

On Apr 8, 4:18*pm, jamal ZETAWI
wrote:
How to get value a field based on of two other columns?
Case:
If the first value in the first column is 23 and the corresponding value in
the next column is AA, I need the corresponding value in the third column to
be 23AA, how to get this result?

Thank you


using A1 and B1 ... this formula woks: =(A1&B1)
note the sign is an ampersand, not a "+" ...