+ Reply to Thread
Results 1 to 5 of 5

Find data in field with Alt Enters

  1. #1
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Find data in field with Alt Enters

    I have a file that has a column with data in it. The data in these cells have Alt Enters, meaning some text is entered, then and Alt Enter to create a second line and then more text. There could be one line or two or three...

    I have another column that has a field that contains (hopefully) some of the text in this first column somewhere in one of the cells. I need a formula that will look for this cells' data in that first column which has the Alt Enters and then sum the numbers in the second. Anyone have any ideas?
    Sample attached.SUMIF Alt Enter.xlsx

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Find data in field with Alt Enters

    You should have showed us what result you expect.

    Here's my best guess...

    =SUMIF(A1:A6,"*"&C1&"*",B1:B6)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Find data in field with Alt Enters

    Try this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  4. #4
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Find data in field with Alt Enters

    Thank you both. This works.

  5. #5
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Find data in field with Alt Enters

    You're welcome. We appreciate the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA that enters TIMESTAMP after data entry, then locks it
    By MichState in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 01:39 PM
  2. [SOLVED] UserForm Enters Final Data Into First Row
    By LoneWolf3574 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2012, 07:46 PM
  3. find data in specific field, paste in specific field of 2nd tab
    By juniperjacobs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2012, 03:10 PM
  4. Splitting Data with Enters
    By Stiffler in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2010, 08:25 AM
  5. find/replace enters
    By search in forum Excel General
    Replies: 2
    Last Post: 01-31-2006, 04:30 PM

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