Results 1 to 4 of 4

Add last word from a string to the beginning of new string

Threaded View

  1. #1
    Registered User
    Join Date
    09-07-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    12

    Add last word from a string to the beginning of new string

    Here is what I would like to do. Just started researching this but I know there are some pretty smart folks on here who might already know it, so here goes.

    Take the last word from string C2 and add it to the beginning of string E2 followed by a space (" "), IF the total number of combined characters does not exceed 24 in length.

    ie.
    C2 = "AM 63/37 032 P3 Telecore+"
    E2 = "5lb SO"
    Combined string would read "Telecore+ 5lb SO" since total length is <=24 characters.

    Or
    C2 = "AM 63/37 032 P3 Telecore+"
    E2= "5lb SO; 4000/RL 10RL/CA"
    No string would place because the combined string would exceed 24 characters.

    Hope that is clear. Thanks for any help and advice.
    Last edited by Delkath; 09-08-2010 at 09:51 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