LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Expanding Data into multiple columns

Hi
I have a large column containing dates is this format

08/12/2008

I want to put the month in it's own column, the day and the year. Basically
split them up into 3 columns.

I have no idea how to go about it.
--
Thank You
Leen
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expanding sequence of data Cong Nguyen Excel Discussion (Misc queries) 4 August 30th 07 03:18 PM
Expanding amount of data in a formula John Excel Discussion (Misc queries) 3 October 27th 06 11:43 PM
ncaa template - expanding formulas for multiple picks Topshelf Excel Discussion (Misc queries) 0 March 18th 06 02:40 AM
sorting data and expanding the selection Barnet1 Excel Discussion (Misc queries) 2 January 23rd 06 01:50 PM
Expanding data Excels Cracking me up! Excel Worksheet Functions 2 November 9th 05 02:07 PM


All times are GMT +1. The time now is 05:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"