Results 1 to 4 of 4

Trim/parse from right within cell - string lengths different

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Hartford, Connecticut
    MS-Off Ver
    Excel 2003
    Posts
    3

    Trim/parse from right within cell - string lengths different

    Frustrated! I have 1 column, 320 rows of email addresses, but when exported from contacts into the .csv format, they all came out as this (examples only):

    (row 1) [email][email protected]
    (row 2) [email][email protected]
    (row 3) [email][email protected]

    ...and so forth. Some have Auto-AddedEmail1, some have AutoAddedEmail1 (with or without the dash - ). Obviously, I want only the email address but I can't figure out how to parse the Auto-AddedEmail1 data. I'm uncertain how to trim (?) 15 OR 16 characters from the right, so I am left with only a valid email address. All I came up with is =trim(RIGHT(A1, [16]) I think I'm close, but not close enough!
    Last edited by oprpjm; 03-26-2013 at 01:32 PM.

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