Thread: Dropdown
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RKS RKS is offline
external usenet poster
 
Posts: 63
Default Dropdown

Hi
I have A,B & C column. In Col A I can use dropdown list and In col B In can
enter some TEXT. I need In column C I can write formula

In Column C =IF(A1"","",CONCATENATE(A1" ",TRIM(B1)))

Please tell me, If any other way because now I can use 3 col. It is possible
for other ways in col A or B
PLease Tell me
Thanks in Advance