Using 2nd and 3rd digits in a cell... 
Author Message
 Using 2nd and 3rd digits in a cell...

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?

AM.



Mon, 14 Apr 2003 22:30:42 GMT  
 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



Mon, 14 Apr 2003 22:36:13 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. If 1st cell is empty, I want data from 2nd cell to copy into 3rd cell

2. Email Address - Using the 2nd and 3rd Email Address Option

3. splitting 3-digit field into a 2-digit and a 1-digit field

4. Resolve to 2nd or 3rd email

5. Get 1st, 2nd, and 3rd Letter From a String

6. OFFSET with array 2nd or 3rd argument

7. Delete every 2nd and 3rd row- VBA

8. Deleting every 2nd and 3rd row

9. OFFSET with array 2nd or 3rd argument

10. Displaying: date: 1st, 2nd, 3rd, 11th, 21st


 
Powered by phpBB® Forum Software © phpBB Group