Adding Enough Blank Spaces To Reach 30 Characters In Between Data In Same Cell.

I am uploading excel data into Inventory Software to populate my warehouse inventory. The upload protocol is Name, Description, Price, etc... all on a .CSV. The issue I my original data has a Description1 and Description2 so I'm having to combine the data into one cell under the Value Header "Description" and upload it through a .CSV file.

Originally Looks like this...
Description1: Mary Had A Little Lamb
Description2: Its Fleece Was White As Snow

Merged to this in a .csv file for upload
Description: Mary Had A Little Lamb Its Fleece Was White As Snow

The Inventory Software then takes the uploaded data and places it in a field in the user interface called "Description". However, if the value exceeds 30 characters it cuts off the remaining characters and dumps the rest into a newly created field it calls "Description2"!!! But it cuts it off right at 30 characters.

Description1: Mary Had A Little Lamb, Its Fle
Description2: ece Was White As Snow

Next example....

Description1: The Quick Brown Fox Jumped O
Description2: ver The Lazy Dog


This is killing my OCD! Is there any way to format a cell, so that once you stop entering in characters it creates empty spaces to reach a defined number of 30 characters. That way when you merge two cells of data together right before converting it to a CSV it would read like, "Mary Had A Little Lamb, _ _ _ _ _ _ Its Fleece Was White As Snow?

Thus your new inventory inventory software would display it as;

Description1: Mary Had A Little Lamb,
Description2: Its Fleece Was White As Snow

Thanks for any help.

Melvosh, thanks but not exactly what i am looking for. Perhaps I'm not explaining myself properly. I have entire spreadsheet of "Items" that I must consolidate the Description1 and Descriptions2 into the same cell due to the limitations of the Inventory software I am uploading them to. The software only accepts a single Description header from a .csv. Name, Decription, Price

What it looks like in Excel before the conversion to .cvs. EXAMPLE A;
Item Description1 Description2 Price
Widget A 1543460 GY2M0318F030N-GM/MY5015 $12.45
Widget B 11543515 GY2M0635J040N-GM/MY5015 $15.45
Widget C 11543638 GY2M0400G020N-MS/MY5015 $2145

Convert to a .cvs I must merge the descriptionsso it looks like this. EXAMPLE B;
Item,Description,Price
Widget A,543460 GY2M0318F030N-GM/MY5015,$12.45
Widget B,543515 GY2M0635J040N-GM/MY5015$15.45
Widget C,543638 GY2M0400G020N-MS/MY5015,$2145

Now once it's uploaded into the Inventory software, it takes the information and breaks it up if the value exceeds 30 characters and actually creates a "Item2" or a "Description2" etc... So it ends up looking like this in the Inventory Software interface with the last but of the Description cut off and placed into a "Description2" filed.

EXAMPLE C
Item: Widget A
Description: 11543460 GY2M0318F030N-GM/MY50
Description2: 15
Price: $12.45

EXAMPLE D
I want it to look like this;
Item: Widget A
Description: 11543460
Description2: GY2M0318F030N-GM/MY5015
Price: $12.45

I dont know if there is a formula that will add spaces to the original Excel Description1 cell so when I merge the Decription1 and Description2 cell for the purpose of converting it to a .cvs so that I can upload it... Looking something like this;

EXAMPLE E
Widget A, 11543460 _ _ _ _ _ _ _ _ GY2M0318F030N-GM/MY5015,12.345

The dotted line "_" represents spaces are are not actually visible. This way when the Inventory software gets a hold of it It will recognize the spaces an give me my desired look in EXAMPLE D ...