## 26 posts tagged with columns. Displaying 1 through 26 of 26. Subscribe:

Which columns would you consider the best of the genre? What posts were particularly memorable?
posted by kingfishers catch fire on Nov 16, 2016 - 29 answers

## Excel formula: Letter to Number (and vice versa)

I'm working on a formula (not a macro) to convert a Letter (in this case, a column letter) to a Number, and vice versa. So: A = 1, B = 2, C = 3, Z = 26, AA = 27, AB = 28, AC = 29, ZZ = 702, AAA = 703, AAB = 704, AAC = 705, BAA = 1379, etc... Of my three part formula(s), I have the one-letter and two-letter columns working, but I run into issues with the three-letter columns (AAA and beyond).
posted by JimBJ9 on Dec 3, 2014 - 12 answers

## Blog Design Best Practices, Column and Width Edition

Current blog design best practices. I'm redesigning my 2-year-old food blog. This is strictly a DIY affair, and any knowledge I have of blog design was arrived at by hours of googling and crying. So, you know, I am big on ideas, but don't have much official knowledge about design. A few specific questions about columns and page size inside...
posted by Bella Sebastian on Feb 12, 2014 - 5 answers

Nothing helps me fall asleep at night like a well-written advice column. My current favorites are Dear Prudence, She Said, She Said, and The Gentleman Scholar. Who else might I like?
posted by The corpse in the library on Nov 8, 2013 - 34 answers

## How can I separate this data column properly?

Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,​ask:3,​meta:2,​projects:5,​jobs:5,​music:6,​irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this?
posted by iamkimiam on Sep 21, 2012 - 7 answers

## Do columnists write their own columns?

Do columnists write their own columns?
posted by Jagz-Mario on Oct 17, 2011 - 15 answers

## Match multiple columns in excel/access

I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such:
posted by thankyoumuchly on Sep 8, 2011 - 3 answers

## Oh, Loathe is too nice a word...

How can I use a column in an excel sheet to automatically become the comments for a corresponding column?
posted by rich on Aug 6, 2011 - 3 answers

## Using Table data to automatically (re)name worksheets in Excel 2007?

In Excel 2007 can I use data in a column on one spreadsheet to automatically change the name of another spreadsheet in the same workbook?
posted by Lentrohamsanin on May 10, 2011 - 2 answers

## How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel?
posted by teg on Dec 6, 2010 - 14 answers

## What is the technical term for these Pompeiian columns?

Can anyone tell me what the architectural or sculptural term is for these low, narrow columns with busts of deities or heroes on the tops of them? (Or tell me a good source for finding such a term when you have a picture, like this one, which was taken in Pompeii?)
posted by manos_frias on Dec 1, 2009 - 7 answers

## Excel column matching

How to remove content from table that is not in other column
posted by tseo on Sep 18, 2009 - 4 answers

## Help me fix my wordpress theme for internet explorer? (YAML)

Web design panic! Wordpress theme (YAML + sandbox) implodes on impact with internet explorer
posted by yuletide on Apr 21, 2009 - 11 answers

## Valid solution to the CSS equal height columns problem?

Is this a good way to solve the equal height columns problem in CSS?
posted by dolca on Mar 15, 2009 - 32 answers

## Column limits suck

Editor for very large flat files?
posted by ROU_Xenophobe on Feb 5, 2009 - 20 answers

## Tabs, pseudo-columns, and wrapping lines

Name. Tab. Phone number. This creates two columns. One for name and one for phone number, except--when someone has a really long name that goes past the tab setting and impinges on the phone number area. Is there some sort of tab setting that will make that long name wrap around, creating a second line within its own name area? For the record, I know I could use a table to do exactly this, but I'm reformatting a huge amount of text that is already laid out with tabs. Any advice for this poor sap who accepted the job? The text is in an InDesign document, but I can copy it to a word processor or anything that would do the trick. Thanks!
posted by largecorp on Jul 18, 2008 - 13 answers

## Where to Buy Inexpensive Wood Columns?

My wife and I are looking to make our entertainment room look somewhat like an Opera house. Any ideas for procuring inexpensive-columns?
posted by mincus on Apr 5, 2008 - 12 answers

## How can I get Keynote to print slides in multiple columns?

How can I get Keynote '08 to print slides in more than one column?
posted by 4ster on Jan 10, 2008 - 2 answers

## Columns vertically uneven in Indesign

Typographers of the world, help me! How does one get lines of type to line up precisely in a two-column format?

## Making two columns work in MS Word shouldn't be this hard.

In Microsoft Word 2003, I'm trying to format a document so that there is both one-columned and two-columned text on the same page. Whenever I apply two columns to the text I want to be in two columns, it always shunts all that text to a new page, as if I had inserted a page break. What do to?
posted by midatlanticwanderer on Jan 30, 2007 - 18 answers

How do I do multiple sets of multi-column divs w/ CSS inside other multi-column divs? More details in first comment.
posted by Kickstart70 on Nov 28, 2006 - 9 answers

## Excel: moving data from multiple columns to a 2-column format

Excel / VBA help needed: moving data from multiple columns to a 2-column format
posted by blag on Aug 17, 2006 - 9 answers

## I just wanna hide!

I have an Excel worksheet populated with data from columns A through IS. I’d like to hide columns but I am getting the following error: “Cannot shift objects off sheet.” Why?
posted by phoenixc on Jun 19, 2006 - 5 answers

## How to correctly export columnar labels from Word into Excel?

A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file.
posted by empyrean on Jun 6, 2006 - 6 answers

## Reverse column order in Excel?

Using MS Excel 2002 (Win), my mom has managed to reverse the order of the columns at the top of the page (Z to A instead of the usual). _Not_ the actual cell entries, but the columns themselves appear in reverse order. She has no idea how/when she did it.
posted by rexruff on Nov 11, 2005 - 3 answers

## Blue steel columns - what's up with that?

Occassionally found on the sidewalks of Seattle, and probably other cities, steel blue columns stand about three feet tall, bolted down to the concrete. About seven inches in diameter, they are topped with a cap one foot tall with a door in the side. A padlock keeps the door shut. What are these things?
posted by tomharpel on Sep 18, 2004 - 17 answers

Page: 1