Results 1 to 2 of 2

Formula to extract part data from a cell

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2009
    Location
    Nottingham
    MS-Off Ver
    Microsoft D365
    Posts
    93

    Formula to extract part data from a cell

    Sorry if the title is a little vague but what i need to do if possible is create a formula to extact a item of data from a cell that has lots of other data in.

    Ive attached an example what i want to do is from the data in colunm A is extact the first 2 digits (in this case 18) and place them in column C under height, then take the next 2 digits after the * ( againin this case 18) and place them in column D under width, then finally take the last few digits after the 2nd * and place them in column E under Legnth?

    Is this possible?
    Attached Files Attached Files

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