View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick@Draper[_2_] Rick@Draper[_2_] is offline
external usenet poster
 
Posts: 2
Default Add text to a column based on text in a different column

I have a long column of 4 character letters that I would like to replace in
another column with 3 characters eg AAA1 to AAA. Is there any type of if
statement?