Formatting Excel 1

[tdion]

Does anyone know how to format tab delimited plain text imported into Excel?

For example.... how would one make the following bold or change the font size.... etc....

COLOR<tab>QUANTITY<tab>WEIGHT<CR>
red<tab>3<tab>3 lbs<CR>
green<tab>5<tab>5 lbs<CR>
blue<tab>8<tab>3.5 lbs<CR>

Are there any formulas that will change the font attributes of a cell?

 

[ETID]

Do you mean other than hilighting the cells and using the format tools in the menu?

 

[tdion]

Exactly. I would like all cell manipulations possible (including highlighting, showing gridlines, etc...) that can be manipulated from the value inside a cell.

For example.... in HTML <b>Hello</b> will bold the Hello. Does anyone know of attributes that can be applied to the value of a cell that will do this?

Because I am dealing with tab delimited plain text, I am limited to this form of formatting the spreadsheet because no programming can be done.

 

[xlbo]

can't be done in excel I'm afraid - all formatting is carried out by actions not by value tags although if you save a spreadsheet as HTML, it WILL create formatting tags for you. The only way I can see this being close to what you want is to import the text file, do your formatting manually and save the excel file as HTML - this should then give you the HTML tags that excel can recognise. They WON'T however, be recorded IN the cell - as soon as the file is imported back into excel, the formatting will be re-produced but the tags will go.

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[tdion]

Very helpful.. Thanks.