+ Reply to Thread
Results 1 to 4 of 4

how do I add spaces to Excel 2016 text please

  1. #1
    Registered User
    Join Date
    09-21-2016
    Location
    Devon, England
    MS-Off Ver
    excel 2016
    Posts
    2

    how do I add spaces to Excel 2016 text please

    Hi,

    I have an Excel 2016 spreadsheet with text like this:

    promotions.FEATURESExteriorsurfaces and doorframesstainless steel finish.Interior

    Is there an easy way to put spaces in please? There are over 10,000 items and the descriptions are different & I can't find a common denominator to find/replace.

    Thank you

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,373

    Re: how do I add spaces to Excel 2016 text please

    Where do you want spaces?

    post a small file of representative sample showing required outcomws.

    To upload a file click "go Advanced" then scroll down to "Manage Attachments"

  3. #3
    Registered User
    Join Date
    09-21-2016
    Location
    Devon, England
    MS-Off Ver
    excel 2016
    Posts
    2

    Re: how do I add spaces to Excel 2016 text please

    Ideally I'd like it to read properly, so:

    promotions.FEATURESExteriorsurfaces and doorframesstainless steel finish.Interior

    would become:

    promotions. FEATURES Exterior surfaces and door frames stainless steel finish. Interior

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: how do I add spaces to Excel 2016 text please

    This looks like an impossible task!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  2. Import text with spaces into Excel
    By tmccar in forum Excel General
    Replies: 4
    Last Post: 01-28-2016, 12:35 PM
  3. Excel: replace all 2 spaces to FF/LR in column of text
    By Bill Craig in forum Excel General
    Replies: 4
    Last Post: 06-07-2006, 12:45 PM
  4. How can I replace spaces in text cells (excel) with underscores?
    By JB2006 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-20-2006, 01:10 PM
  5. [SOLVED] Getting Notepad.exe text in Excel including leading spaces
    By Sally in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 06:15 PM
  6. [SOLVED] Getting Notepad.exe text in Excel including leading spaces
    By Sally in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2005, 06:15 PM
  7. [SOLVED] remove spaces in text in excel
    By GnarlyCar in forum Excel General
    Replies: 3
    Last Post: 02-01-2005, 01:06 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