A B 09-May may 11-Apr apr 16-May may 05-Jun jun 06-Jun jun 10-May may 11-Jun jun 03-Nov jun 31-May may 13-Jun jun 10-Jul july 04-Apr apr 16-May may I have coloumn A with verious month's date I want to show as text massage that I do not concerne any date between 1 to 31 but in coloumn B I want as a text massage like APR,MAY,JUN to MAR.of date"s month in B coloumn, Sir ,please help me which formula can I use for the same ?

Since all month names starts in position 4, try =Concatenate(A1;4;3). Nigel This is just a sig

or, if it's in date format, use the TEXT() function: =TEXT(A1,"mmm")

I offer this more complicated solution just as a learning exercise. Figuring out how it works might just help you later on. In C1:D12 (or anywhere else you like) put in this table: 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December Then use this formula, matching the C1:D12 to the actual location of your table. =VLOOKUP(MONTH(A1),C1:D12,2)