Formating 2005345 to only 34!

[a94andwi]

Hello I got this date 2005345 which means year 2005, week 34, day 5
I want excel to format these values 2005345 and only show W34
How is this possible?

/Anders

 

[Roger Govier]

With data in A1 try
="W"&MID(A1,5,2)