View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich0072
 
Posts: n/a
Default how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2

I have addresses which were entered in cells a1, A2, A3 and so On and I need
to convert them to appear in cells a1, b2, b3 I know I have performed this
function in the past but I am drawing a blank please help.