View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] radlee@progressivetel.com is offline
external usenet poster
 
Posts: 5
Default Help! Excel Question

Thanks! Worked like a charm! You guys are great!'

Lee


Carim wrote:
Hi Bill,


1. ="*"&A1&"*"
2.
="*"&B1&RIGHT(B1,1)&MID(B1,4,1)&MID(B1,3,1)&MID(B1 ,2,1)&LEFT(B1,1)&"*"

HTH
Cheers
Carim