You are here: HomeExcelTutorials

# formula getting first two numbers in another cell

## formula getting first two numbers in another cell

Price: FREE

in finding the right formula getting only the first two numbers of a date.
Example1:
Cell a1
01-Jan-10
Cell a2
Example2
Cell a1
23-Mar-10
Cell a2
I need a formula in cell a2 that only gets first two numbers of another cell.

Visit publisher's web-site: formula getting first two numbers in another cell

Category and Tags: ExcelTutorials :

## Related Tutorials

### Counting Numbers Formula

Free: Yes
Tags: Excel ›

a newbie here but I wonder if anyone could help me please.
I would like a formula that will be able to count in between odd/even numbers...
So for example:
The numbers in between 1-9 odd, (including both 1 and 9) is 5 so in Excel I would like to put in Cell A1 the number 1 and then in Cell A2 the number 9 and the formula in Cell A3 would automatically give the number 5.
Hope this all makes sense and any help would be HIGHLY appreciated!

### Numbers condition

Free: Yes
Tags: Excel ›

I want are numbers automatically in yellow cell if was a value in red cell below it not equal zero
and the numbers be sequential and start with numbers from (1-50) and if was there empty cell for example (E4) not numbers (E2)
and numbers the followed cell (G4) if (G4) was contained a value
if the numbers reach to (50) then restart the numbers from number (1- 50)
for more explanation , there are attached below

### formula for automatic up on numbers in cell in exel

Free: Yes
Tags: Excel › Functions

Want to advance numbers automatically for invoice numbers. Needs to be for single cell in Excel. Need formula.

### two arrays correction

Free: Yes
Tags: Excel ›

the freest one fell apart when it sent. I am trying again.
In col A through F there are numbers about 150 rows down.
In G1 through L1 there are numbers and these will change from time to time.
G2 through L2 and down I want a formula that will find the numbers that
are in A through F and put YES in the corresponding cell under G to L.
So any cell in A:F that has one of the numbers in G:L the formula will
put yes in the corresponding cell under G:L if the numbers is in G1:L1.
A B C D E F G H I J
32 21 5 23 50 Yes 9 43 21 18 22 Yes 2 34 1 54 8 Yes Yes

### Delete Other Numbers Except Cell Numbers

Free: Yes
Tags: Excel ›

I am new to use MS Office Excel 2010. I have 10 Lac Numbers but all numbers are mixed with each other like fax or land line numbers but I need only cell numbers except other numbers how can I do it.
cell numbers starts from "03". Like: "0300-1234567" but some cells have data like this (042-1234567 0300-1234567) How can I separate it.
All numbers are paste in A Column. How can I do it.

## Related Applications & Scripts

### Flip Numbers

Free: No
Tags: Flash › Excel Random Text

This display allows you to show any number with style. It is easily and fully customizable:
change dimensions.
choose how many numbers visualize.
change the background color of the numbers.
change the numbers color.
change the distance between numbers.

### Key Generator

Free: No
Tags: ASP.NET › Excel Random Text

The KeyGenerator is a .NET component for .NET applications that allows to developers generate random values using the combination of numbers, letters, characters and custom values.
Principal features:
- Get random values using Numbers, Letters, Numbers & Letters, Numbers-Letters-Characters or custom values defined by you
- Include source code so you can add custom elements
- It is compatible with C# and VB projects (include demo apps for both)
- It is compatible with different types of .NET projects (web, desktop, console)

Free: No

The Counter Preloader is a simple, percentage-based preloader that displays the loading progress of your SWF in text. As the loading progresses, the numbers in the counter increment with a blur effect. The numbers are given a glow and set upon a lighted surface. The entire setup is placed slightly off the center of the stage, and adjusts itself automatically to stage resizing and fullscreen events.

### Pixel Block Text AS2

Free: No
Tags: Flash › Excel Effects

Block Text with pixel cubes creating letters and numbers. Capital letters, numeric digits plus extra exclamation mark. Easy to use and customize with component parameters. Among them:
- 2 types of numbers, see below;
- Delay between letters;
- Spacing between letters;
- Speed/ duration of blocks movements;
- Horizontal and vertical blocks movement distances;
- Direction of in/ out blocks;
- Scale and Fade in/ out option for blocks;
- Shake blocks;
- Shake movement distance.