+ Reply to Thread
Results 1 to 3 of 3

Insert space between numbers and text

  1. #1
    Registered User
    Join Date
    04-23-2018
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    1

    Insert space between numbers and text

    Hi All,
    please help me for this problem with formula
    i need to let this text+number to auto space , after that copy the formula to auto drag.

    LE179620006MY
    LE179620058MY
    LE179620059MY
    LE179620050MY
    LE179620053MY
    LE179620054MY

    the result should be like this.
    LE17 962 000 6MY
    LE17 962 005 8MY
    LE17 962 005 9MY
    LE17 962 005 0MY
    LE17 962 005 3MY
    LE17 962 005 4MY


  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Insert space between numbers and text

    In A1 Cell

    LE179620006MY


    In B1 Cell

    =IF(A1="","",TRIM(LEFT(A1,4)&" "&MID(A1,5,3)&" "&MID(A1,8,3)&" "&MID(A1,11,3)))


    Drag B1 Cell formula down


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Insert space between numbers and text

    Then there is the "brute force" approach. (I had to put spaces in the replace function. Sucurri kept rejecting the formula.)

    =REP LACE(REP LACE(REP LACE(A1,11,0," "),8,0," "),5,0," ")
    Dave

+ 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] Insert space between numbers and text
    By dleslieca in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-25-2017, 06:24 PM
  2. Please help! loop/Insert text in first blank space
    By pkilsby1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2015, 02:29 PM
  3. [SOLVED] Insert space in part numbers
    By Allgermanparts in forum Excel General
    Replies: 4
    Last Post: 06-19-2013, 09:00 AM
  4. [SOLVED] Long String of text and need to insert space every 8th character
    By jbang917 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2013, 03:45 PM
  5. [SOLVED] Insert a space in front of all upper case text
    By excelrod in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2012, 12:02 PM
  6. [Solved] Removing numbers and space before text
    By loyski in forum Excel General
    Replies: 5
    Last Post: 02-07-2012, 11:36 AM
  7. How can I insert a space btw lines of text?
    By jspence in forum Excel General
    Replies: 1
    Last Post: 06-17-2011, 01:56 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