In Excel how would you hide the text in a column without the hide function or making text "white"?

1. Select the cell you want to hide

2. Hit CTRL+1 (or open format cells dialog from right click)

3. Go to Number tab, select “custom” as the type

4. Type the formatting code as “;;;” without double quotes

5. Press OK and your cell contents are invisible now

1- Select Text and go to Format CELL . Just select a custom format and enter a space. The dialog looks like this

2-2nd option is CONDITIONAL formatting

I like your way. Asking then answering ...:)

using  this format ;;;

You can hide the text by using cutting function by (CTRL+X). Then you can unhide it by using paste function by (CTRL +V)..