software

Not sure what you're asking, but the INDIRECT function somes to the rescue:
something like =INDIRECT(LEFT(SuppName,2)amp;MID(SuppName,4,4)amp;quot;BDquot;) would make
40CHANDB be a reference, but to what is this referring?? If it's a workbook,
then you'd need the [ and ] characters, the sheet name, the exclamation mark
amp; a cell reference, etc, but that could also be part of the INDIRECT. Perhaps
Microsoft Help can explain further.

quot;Aliquot; wrote:

gt; please have a look and ill appreciate any help.
gt;
gt; Supplier Name gt;gt;40 Chantress Close, Dagenham, Essex
gt;
gt; i need to create refrence for above property somthing like this
gt;
gt; Ref Required somthing like this gt;gt;gt; 40CHANBD
gt;
gt; whereas quot;40quot; is the first two words, quot;chanquot; the second four words and quot;bdquot;
gt; represent council i.e. barking and dagenham. make note quot;bdquot; have to be shown
gt; in formulae so as to add to the refrence.
gt;
gt; thanks for help in advance. cheers ali