Results 1 to 6 of 6

Trim formula

Threaded View

stemcell1 Trim formula 10-23-2008, 10:53 AM
Ron Coderre Parsing text 10-23-2008, 11:08 AM
stemcell1 Thanks Ron! That was very... 10-23-2008, 11:17 AM
martindwilson well for first part ... 10-23-2008, 12:23 PM
Ron Coderre Parsing text with a delimiter 10-23-2008, 12:39 PM
stemcell1 That is probably the longest... 10-23-2008, 12:39 PM
  1. 10-23-2008, 10:53 AM #1
    stemcell1 is offline
    Registered User
    Join Date
    05-23-2007
    Location
    San Diego, CA
    Posts
    59

    Trim formula

    I have been using the following formula's to trim some information that's separated by a colon, such as Pioneer Clinic:Dave McAfee...so that I have a column with Pioneer Clinic and a column with Dave McAfee:

    =LEFT(G5,FIND(":",G5)-1)
    =TRIM(RIGHT(G5,LEN(G5)-FIND(":",G5)))

    However, now some of my data is separated by two colons!
    AVM:Pioneer Clinic:Dave McAfee

    Can anyone show me the formula for separating this so I still have two columns of Pioneer Clinic and Dave McAfee?

    Thanks!
    Last edited by VBA Noob; 10-23-2008 at 12:46 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1