Custom text formatting in Excel 2000
 

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?

Custom text formatting in Excel 2000
 

Use this:

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

It should work.

HTH,
CoRrRan

"?B?S2V0Y2h1cA==?=" wrote in
:

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?