+ Reply to Thread
Results 1 to 6 of 6

formula for inserting a space betwen characters

  1. 10-17-2018, 11:31 AM #1
    srinivasan1965
    srinivasan1965 is offline
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    formula for inserting a space betwen characters

    hi
    I need a formula to insert a space between a text
    I need to do for above 2000 records
    please help
    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-17-2018, 11:35 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: formula for inserting a space betwen characters

    Try
    =LEFT(A2,5)&" "&MID(A2,6,LEN(A2)-6)&" "&RIGHT(A2,1)
    Reply With QuoteRegister To Reply
  3. 10-17-2018, 11:37 AM #3
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: formula for inserting a space betwen characters

    Another way.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Dave
    Reply With QuoteRegister To Reply
  4. 10-17-2018, 01:00 PM #4
    myou
    myou is offline
    Registered User
    Join Date
    02-22-2016
    Location
    Harare, Zimbabwe
    MS-Off Ver
    2007 & 2010
    Posts
    71

    Re: formula for inserting a space betwen characters

    @FlameRetired,

    Good one Dave!
    Happy? Click the * to the left.
    Reply With QuoteRegister To Reply
  5. 10-17-2018, 02:23 PM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: formula for inserting a space betwen characters

    Thank you.
    Reply With QuoteRegister To Reply
  6. 10-18-2018, 01:27 AM #6
    srinivasan1965
    srinivasan1965 is offline
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: formula for inserting a space betwen characters

    thanks a lot
    This also works find
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Inserting Space In Cells
    By khemistry1911 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2014, 11:32 AM
  2. Formula to return characters after a letter and before the first space
    By jimmyb555 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2014, 07:04 PM
  3. Formula Help- Inserting characters around cell contents
    By dbforum29 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-24-2007, 02:00 PM
  4. cHARACTERS BEFORE THE SPACE
    By T De Villiers in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2006, 09:30 PM
  5. Characters before the space
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2006, 06:25 PM
  6. [SOLVED] Inserting a Space in The Same Place Formula
    By carl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2005, 08:06 PM
  7. re inserting a 2 row space between data
    By hoganc in forum Excel General
    Replies: 1
    Last Post: 01-05-2005, 08:26 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1