+ Reply to Thread
Results 1 to 2 of 2

How to put spaces between words?

  1. #1
    Registered User
    Join Date
    08-05-2019
    Location
    Dubai, UAE
    MS-Off Ver
    2017
    Posts
    1

    How to put spaces between words?

    I have an excel file that contains thousands of different inventory items. In one column that is for the product title/product description all the wording is run together with no spaces. Most of the wording is properly spelled with no abbreviations. I am wondering how to go about adding spaces between the words for over 8000 items besides doing it manually. Is there some sort of automation/formula I could do to run a spell checker thru it and add a space between words it detects(sorry if I am way off base on this)? Any suggestions would be helpful. I am lacking the imagination and/or skill to think of it.

    Thanks in advance,

    pollux21

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: How to put spaces between words?

    Manual is probably your only option.
    Consider the word "invent"
    Is that "invent"?
    Or "in vent"?

    Excel's not gonna know that.

    Manual would be your only option I reckon.
    That or go back to the source of your file and tell them you can't work with data in that format (and shouldn't be expected to).
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create spaces between words
    By Vandacardoso in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-25-2015, 01:17 PM
  2. How do i add spaces between words in bulk?
    By gsmonk in forum Excel General
    Replies: 6
    Last Post: 10-23-2014, 04:50 PM
  3. Trying to add spaces between capitalized words with a formula
    By syncguy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2014, 04:21 PM
  4. Remove all spaces between words
    By Melf72 in forum Excel General
    Replies: 6
    Last Post: 09-06-2010, 08:11 PM
  5. Delete spaces between words
    By kolovel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2010, 08:07 PM
  6. removing spaces after words
    By Chemistification in forum Excel General
    Replies: 4
    Last Post: 10-21-2009, 08:47 AM
  7. [SOLVED] Remove spaces between words
    By Heather Tavitian in forum Excel General
    Replies: 2
    Last Post: 09-30-2005, 09:05 PM

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