Formatting involving year

Guest · Oct 13, 2007

In a column I have a current setup of "yy-#####" (ex: 96-12345) I want
"Ryyyy-#####"(ex: R1996-12345). Also, I have data from 1990-current. Any
tips?

Guest · Oct 13, 2007

Try something like this

="R" & IF(VALUE(LEFT(A1,2))<=7,"20","19")& A1

Guest · Oct 13, 2007

Thank you!

Barb Reinhardt said:
Try something like this

="R" & IF(VALUE(LEFT(A1,2))<=7,"20","19")& A1

Rearranging data	3	Jun 4, 2009
How to remove characters in a cell that precede a specific hyphen	17	Apr 4, 2008
Can Excel List specific data from a list? NOT Autofilter??	8	Oct 20, 2008
Formatting Decimal points	2	Sep 30, 2006
How can I copy characters from a cell that follow a hypen	2	Apr 3, 2007
Lookup Function	3	Aug 19, 2009
Formula Question	2	Jul 15, 2009
Sorting Count Values in Pivot Table (Excel 2007)	1	Dec 29, 2009

Ask a Question