View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saintsman Saintsman is offline
external usenet poster
 
Posts: 81
Default if cell is text move left one column

ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
ColB.
Doors
940590
555998
447006
447008
810697
810705
810706
810707
Windows
619435
525691
525692