One way is to put the 130 spaces in a cell (say A1 ) the
your formula would be
=concatenate(0001,650010,X,1244689,$A$1,X,650010)

-----Original Message-----
Hello all. I have to manupulate an excel sheet into a
specific format, then
save it as a text file to allow for an EDI upload into
SAP. The format the
text file has to be in is very specific, ie an exact
number of spaces and
characters.

I have the outline of what needs to be done, my question
is this - I am
going to do several concatenations to get the data in the
correct format. A
few of the concatenations consist of 130 spaces (hitting
the space bar 130
times). I'd like to write code to manipulate the data.
Is there a way to
tell excel to insert 130 spaces, rather than me hitting
the spacebar 130
times? So pseudo vba would look like:
=concatenate(0001,650010,X,1244689,{syntax for 130
spaces},X,650010)

Thanks!


.