View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Mass adding of text

List your desired rules and we will build them into the formula.
--
Gary''s Student - gsnu200779


"Shae" wrote:

OK, I get where you both are coming from. Is there a way to have it select
certain cells? i.e. "A1 if it begins with 2"? Some of the numbers don't
need the number.