Wade Smart wrote:
Harold Fuchs wrote:
265879-09-24-71-918-333-0055
Assuming the "71" part of your string is always in the same position
- two
characters long, starting at the 14th character - and assuming the
strings
are in column A and you want answers in column B, then enter into
column B
the formula
=YEAR(NOW())-1900-VALUE(MID(A1;14;2))
In fact, if your strings are fixed format then using the MID function is
much easier than my previous solution using Regular Expressions.
I get ERROR: 502 when I try this.
On my version of OO I have to use , instead of ; - though I still get
the error.
Question. I looked up Value and it says it converts a text string to a
number. If we are already working on a number, is that needed?
Wade
I took one of the numbers and changed it to text and this worked fine.
But when I change it back to number, it does not.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
