Thread: cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bearacade[_38_] Bearacade[_38_] is offline
external usenet poster
  
Posts: 1
Default cell a1 mod No(abc??d) cell b1=unit size(10) a1 would be abc10d

Try this.. But I am not sure if this is what you are asking..

Put this in A2:

=LEFT(A1,FIND("?",A1)-1)&A2&RIGHT(A1,LEN(A1)-FIND("?",A1)-1

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=57007

Reply With QuoteReply With Quote