Formatting a range of cells

  • Thread starter Thread starter ClackerDacker
  • Start date Start date
C

ClackerDacker

Hi,

I have a range of cells that have come in from another app that have
basic formatting instructions as part of the text, i.e.

2.33|b| where |b| means this should be bold
4.26|o| where |o| means I have to display the cell with blue text

Now I'm currently doing this is ssslllooowww way of going thru the
cells and checking each one.

Are there any tricks I can use to quickly format the cells as required
AND remove the formatting detail from the cell, i.e.

2.33|b| becomes *2.33* and 4.26|o| 4.26?

I hope someone can make my app speed up ;)

TIA
 
Hi,

The first part of the job, to separate the value from the formatting code, can be done with Data>Text to Columns with "|" as separator. Format the source column as number before you do Text to Columns.

For the second part, to format the number column according to the format code column, you need a macro. No big deal.
To bother creating a macro depends on how many entries there are, and if this is a once only job or something you will have to do on a regular basis.

HTH
Anders Silvén
 
Back
Top