Let's say that A1: "01.01.2013 01:00:00 +01:00"
In B2 I only want "01", and in C2 I only want "2013". Could someone please explain how?
Btw: Does anyone know about a nice graph/chart program for Windows (except Excel)?
Let's say that A1: "01.01.2013 01:00:00 +01:00"
In B2 I only want "01", and in C2 I only want "2013". Could someone please explain how?
Btw: Does anyone know about a nice graph/chart program for Windows (except Excel)?
You coud use:
=MID(A1,4,2) for 01, and
=MID(A1,7,4) for 2013
assuming htta the number format remains the same. If you want to use the results as numbers (they are returned as text), then put -- before the MID in both cases.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks