Using 2nd and 3rd digits in a cell...
Hi Aris,
Quote:
> If I have a seven digit number in a cell and want to use the 3rd 4th...
> numbers in it for a formula what is the function I need to use?
Same as you use on Worksheet Function
=MID(A1,3,2)
MyNewString = Mid(MyString, 3, 4)
works on either side: function (above) or statement (below)
Mid(MyString, 5, 3) = "duck" ' MyString = "The duc jumpe".
HTH, works same on numbers (left to right)
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
