Results 1 to 8 of 8

Unable to split text and numbers into Separate Cells that have no space

Threaded View

BDavis Unable to split text and... 01-21-2013, 02:03 PM
Miraun Re: Unable to split text and... 01-21-2013, 02:06 PM
oeldere Re: Unable to split text and... 01-21-2013, 02:12 PM
BDavis Re: Unable to split text and... 01-21-2013, 02:17 PM
Ron Coderre Re: Unable to split text and... 01-21-2013, 02:18 PM
BDavis Re: Unable to split text and... 01-21-2013, 02:39 PM
BDavis Re: Unable to split text and... 01-21-2013, 03:03 PM
Ron Coderre Re: Unable to split text and... 01-21-2013, 04:39 PM
  1. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Unable to split text and numbers into Separate Cells that have no space

    If it's always that way.

    See the file for the formula's

    b1
    =Left($A1,6)
    c1
    =Right(Left($A1,10),3)
    d1
    =Right($A1,6)
    Attached Files Attached Files
    Last edited by oeldere; 01-21-2013 at 02:14 PM.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

Thread Information

Users Browsing this Thread

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

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