Fixed length cells

[compyr]

Hello All!

I'm sure this is very simple but I can't figure it out. I need to create a column and put exactly 2 spaces in it. Creating the column is no big deal but it seems that I cannot put 2 CHAR(32) in the same cell. What am I missing? THX!

compyr

 

[Damon Ostrander]

Hi compyr,

If you are dead set on entering the spaces using a formula and the CHAR function, you should be able to do

=CHAR(32) & CHAR(32)

But if you don't have to use the CHAR function you could just do

=" "

And if you just want two spaces in the cell as a constant, rather than a formula, just type two spaces in the cell.

Damon

 

[compyr]

Thank you for the reply. I did finally figure it out. What I am trying to do is to import a text file, delete all info execpt for what I need, and then make a fixed length record to be sent to the mainframe and checked for accuracy. I am sure that this has to be done with VBA but I'm not very good at it yet. I was trying to find the quick and dirty solution but I guess I'll just have to hit the books harder.

compyr