How do I export text with specified spacing between words?

[Fucius]

Hi again everyone,

I'm not sure if it's possible to do this in excel but How do I export text with specified spacing between words? I'm trying to figure this out for work so I don't have to manually type everything in, all I do is import this text file into our system. So anyway... I need to be able to export text containing 109 spaces preceding an ID consiting of 8 letters following by a description with preceding spaces of say 200 spaces.

ie: (109 spaces literally) -> ID [8 letters] -> (200 spaces) ->Description

Any help would be greatly appreciated!

 

[rconverse]

What do you mean export? Export to where?

You can create 109 spaces using rept.

=REPT(" ", 109)

So something like this maybe? (Assuming ID is in B1 and description is B2)

=REPT(" ", 109) & B1 & REPT(" ", 200) & B2

 

[Fucius]

I need to be able to export the data as a text with the following format:

(109 spaces literally) -> ID [8 letters] -> (200 spaces) ->Description

 

[rconverse]

Where are you getting ID and description? Assuming your ID and Description are in columns A and B and they have headers you can use this.

=REPT(" ", 109) & A2 & REPT(" ", 200) & B2

Copy down. Next copy and paste your new column as values, delete columns A & B, and save as text.

HTH,
Roger

 

[Fucius]

rconverse,

SWEET! This works! I managed to get it to work but is there a specific place to paste your code? Do I paste it after inserting my column A & B data? if so, where? (Sorry, I'm a complete newb to this stuff) Thanks so much!

 

[rconverse]

Assumng your ID is in colnm A and your description in B, you can insert that formula in colnm C and then copy down the spreadsheet.

 

[Fucius]

ahhh... okay, got it! This is awesome! thanks again so much, works like a charm!