+ Reply to Thread
Results 1 to 2 of 2

Insert spaces in text string

  1. #1
    Registered User
    Join Date
    03-21-2020
    Location
    brazil
    MS-Off Ver
    2019
    Posts
    7

    Insert spaces in text string

    Hello, guys!

    I have a column with thousands of text values as follows:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    How can I insert spaces before and after the plus sign, and add another space and a equal sign to the end of the string?
    So, for example,
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    would become
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Thanks in advance!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Insert spaces in text string

    Hi,

    One way

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    alternatively use the Find and Replace functionality
    Last edited by Richard Buttrey; 05-28-2020 at 04:00 PM.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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: 6
    Last Post: 09-05-2019, 07:45 AM
  2. Advanced string manipulation-Adding spaces to a string
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-22-2019, 08:08 PM
  3. Insert spaces into specific parts of text string
    By southpaw5271 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2016, 11:13 AM
  4. Take spaces out of a string
    By mizunobill in forum Excel General
    Replies: 1
    Last Post: 12-21-2010, 06:36 PM
  5. insert spaces into text string
    By mmwltd in forum Excel General
    Replies: 6
    Last Post: 04-27-2010, 01:05 PM
  6. How to insert spaces in a string please
    By Andrew Thomas in forum Excel General
    Replies: 2
    Last Post: 07-17-2007, 08:49 AM
  7. [SOLVED] Insert Spaces
    By Ronbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2005, 06: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