View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hejde
 
Posts: n/a
Default How to replace a cell if value is alphabetic

I have this chart where I need to combine the contents of 2 cells - A & C -
But if A is alphabetic I need it to combine B & D instead. Any good ideas?

A B C D
WC1 406 20062442 93082813