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!