format cells

Anyone know how to format cells/columns to always show a title be formatted looking like.... "Title, The"?? For example, the movie title "The Replacements" or music artists "The Beatles" to automatically format to look like "Replacements, The" and "Beatles, The". My intentions are to make lists...

Hello, I need to create a file from an excel sheet. The VBA project reads values of cells and write them into the file (ofln): Open OFLN For Output As 1 For IR = 1 To 72 XLINE ="" For IC = 11 To 19 A$ = LTrim(RTrim(Cells(IR, IC).Value)) XLINE = XLINE + Chr$(32) + A$ Next IC XLINE =...

Hi, I haver a sheet that looks like this <TABLE style="WIDTH: 574pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=764 border=0><COLGROUP><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 30pt; mso-width-source: userset...

Up until today, Excel worked fine and I was able to insert rows and columns, copy rows and columns and Insert Copied Cells, and format cells by selecting, right-clicking, and choosing Format Cells. Today I can't do any of those things. I have searched all over the internet and all I have found...

Hi all, I have 2-ish problems. First, I want to create a format that shades every other line grey in my worksheet - however, Excel won't let me do that because I am using AutoFilters. It says they must be disabled in order to format what I have, but I cant afford to undo them. So, I thought...

I have a sheet that routinely has data pasted into it. Sometimes the data that is pasted in has a 13.5 pt. MS Sans Serif font. I want everything on the sheet to look uniform so I would like any text placed in the sheet to instantly convert to a 12 pt. Comic Sans font. I would think the easiest...

I'm using Excel-2007. I exported data from a windows application for analysis/calculations and one of the columns is a time stamp for various transactions. I'll call it the TransTime column. The format of the resultant exported data TransTime column is GENERAL and below is a sample data...

Hi All, I have some code to change the font size of a range of merged cells based on the length of text within the cells. The code works fine when the sheet is unprotected, however when I protect it the code fails with the message "Run-time error 1004 - Unable to set the Size property of the...