(no subject)
Jan. 9th, 2009 08:15 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
nonethefewerToday's thing about Excel that all this time using it, I didn't know:
Say you have a column of names:
Smith, Bob
Jones, Tim
You want to split those out to two columns. Simple-peasy. Go to Data > Text To Columns (this is the same in 2007 - it's found in the Data Tools chunk). That takes you through a wizard that allows you to split the data based on criteria (delimited or fixed width, commas or semicolons, &c). If you've ever imported a .csv into Excel, it's the same wizard.
ALL THIS TIME. And I never knew until YESTERDAY.
Say you have a column of names:
Smith, Bob
Jones, Tim
You want to split those out to two columns. Simple-peasy. Go to Data > Text To Columns (this is the same in 2007 - it's found in the Data Tools chunk). That takes you through a wizard that allows you to split the data based on criteria (delimited or fixed width, commas or semicolons, &c). If you've ever imported a .csv into Excel, it's the same wizard.
ALL THIS TIME. And I never knew until YESTERDAY.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
(no subject)
Date: 2009-01-09 05:18 pm (UTC)(no subject)
Date: 2009-01-09 05:31 pm (UTC)(no subject)
Date: 2009-01-09 08:49 pm (UTC)