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.
Bookmarks