MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chopping up date


Posted by Jason on April 10, 2001 8:56 PM

If I have a cell with a text value of (no quotes):
'Mar 3 1969'

is there a way to seperate the 'Mar' the ' 3' and the '1969' into seperate cells? Basically I want to chop up the text string into seperate cells


Posted by Dave Hawley on April 10, 2001 9:07 PM

Hi Jason

Let's suppose your text is in cell A1. Use these formulas


To get the Month
=LEFT(A1,3)

To get the Day
=MID(A1,5,1)


To get the year
=RIGHT(A1,4)

Or alternatively you could use the "Text to Columns" wizard, found under "Data" on the main menu.


Dave


OzGrid Business Applications

Posted by Jason on April 10, 2001 9:16 PM

Thank you very much your help is greatly appreciated. I will reccommend your site to all that I know.

Jason