Results 1 to 8 of 8

Separate out a text string in one cell, and break into into individual cells

Threaded View

StephenHall Separate out a text string in... 10-27-2012, 03:19 PM
dogberry Re: Separate out a text... 10-27-2012, 03:32 PM
brynbaker Re: Separate out a text... 10-27-2012, 03:58 PM
FDibbins Re: Separate out a text... 10-27-2012, 04:50 PM
StephenHall Re: Separate out a text... 11-04-2012, 07:57 PM
benishiryo Re: Separate out a text... 10-28-2012, 02:02 AM
StephenHall Re: Separate out a text... 11-04-2012, 07:58 PM
brynbaker Re: Separate out a text... 11-05-2012, 03:45 PM
  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    Calgary, Alberta, Canada
    MS-Off Ver
    Excel 2003 / 2007
    Posts
    3

    Separate out a text string in one cell, and break into into individual cells

    Attachment 189810

    What I am trying to achieve is the following:- I have the text string 10"-A1L-FG-21149-01 in cell B5, and
    wish to separate this into its individual components using a formula to cells F5,G5,H5,I5,J5.

    i.e
    F5=10”
    G5=A1L
    H5=FG
    I5=21149
    J5=01

    Please note that F5 and H5 are not always two digits i.e F5 may be 8” for example and H5 could consist of
    no more than 3 digits i.e MFG.

    Would appreciate a method which would best do this by Formula, i tried with amacro but this became to complex
    as the list is filtered and rows are non consecutive.

    Regards

    Steve

    PS:=please refer to attachement
    Attached Images Attached Images

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