Getting digits out of a text string

[Thore]

Hi all,

I have a column with thoe following values.

'75001
'75001
'01120
'01120
'01630
'13380
'13380
'13380

I would like to have the 2 other columns where the first
two "number digits" are displayed, e.g. 75 for the first
two lines, 01 for the third, etc. Which formula can I use?

In a similar problem I would like to extract the month
number from a different column, here the 01, 02 and 05.
Same formula?

'20040129
'20040202
'20040505

Rgds,
Thore

 

[Frank Kabel]

Hi
try
=--LEFT(A1,2)

and for the second one try
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))

 

[SMILE]

If your data is in Col A, then you can type the following formula in Co
B

=MID(a1,1,2)

similarly to find the month you can use

=mid(a1,5,2)

Regards
Tom

 

[Guest]

Hello, try =LEFTB(text,num_bytes)
and fro your second problem try
=MID(text,start_num,num_chars)

Hope this helps
Mark