View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brian
 
Posts: n/a
Default switch number order

i'm trying to figure out if there is any way to switch a column of 6 digit
numbers so that the first 3 numbers are the last 3 and vise versa. example..
111222=222111, or 198321=321198. any help would be welcomed. thanks for
your time.