Results 1 to 6 of 6

Excel 2007 : Add space between characters and numbers in Microsoft Excel

Threaded View

freerdj Add space between characters... 06-04-2009, 07:27 PM
shg Re: Add space between... 06-04-2009, 07:34 PM
freerdj Re: Add space between... 06-04-2009, 11:33 PM
shg Re: Add space between... 06-05-2009, 10:33 AM
saketpadia Re: Excel 2007 : Add space... 10-08-2015, 07:07 AM
Sam Capricci Re: Excel 2007 : Add space... 10-08-2015, 07:26 AM
  1. #1
    Registered User
    Join Date
    06-04-2009
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Add space between characters and numbers in Microsoft Excel

    I am doing data scrubbing where I have ~8000 addresses where only some contain the following "errors" in the string:

    10847Elk Run Rd
    11712Jefferson Ave
    11801Coastal Hwy

    I need a way to search for "numtext" and replace with "num text", regardless of how long the leading number or following Latin string is. The ideal function would add spaces where necessary and avoid those that are formatted correctly.

    10847 Elk Run Rd
    11712 Jefferson Ave
    11801 Coastal Hwy

    Please advise.
    Last edited by freerdj; 06-05-2009 at 11:28 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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