Custom text formatting in Excel 2000

[Guest]

I know I can apply custom formatting to change the appearance of a number.
For example I put in 1122333344 and I can have it appear as 11 22 3333 44.
How do you do this for text? I need to have my text appear like
aa_bb_cccc_dd with the underscore meaning a blank space or separator. Is
there an expert out there who can help me?

 

[CoRrRan]

Use this:

Format("aabbccccdd", "@@\ @@\ @@@@\ @@")
or
Format(strString, "@@\ @@\ @@@@\ @@")

It should work.

HTH,
CoRrRan

 

[Guest]

I know how you made these strings work, but when I type them in the custom
format under format cells, they sure don't work for me so... Any other ideas
out there??