+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Cincinnati
    MS-Off Ver
    Office 365
    Posts
    2

    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.

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

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

    Assuming your text is in A1, try this:
    Please Login or Register  to view this content.
    If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.

    If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.

  3. #3
    Registered User
    Join Date
    05-15-2019
    Location
    Cincinnati
    MS-Off Ver
    Office 365
    Posts
    2

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

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

  4. #4
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

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

    Do you need to modify the Description 1 text directly, rather than use an additional column? If so, it will most likely require VBA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1