+ Reply to Thread
Results 1 to 8 of 8

Can't search for data in combined data cell

  1. 12-28-2023, 06:17 PM #1
    jacko1994
    jacko1994 is offline
    Registered User
    Join Date
    12-28-2023
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Mac 16.53
    Posts
    5

    Can't search for data in combined data cell

    Hi,

    I've used a forumula to mash together the data from 2 cells, namely - the house number and street name of an address.

    The forumula I used was : =D2&" "&E2

    Please see attached

    I now want to search by whole addresses

    But it doesn't work

    Plz help
    Reply With QuoteRegister To Reply
  2. 12-28-2023, 06:37 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Can't search for data in combined data cell

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 12-28-2023, 06:41 PM #3
    jacko1994
    jacko1994 is offline
    Registered User
    Join Date
    12-28-2023
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Mac 16.53
    Posts
    5

    Re: Can't search for data in combined data cell

    Please see attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 12-29-2023, 01:03 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Can't search for data in combined data cell

    Where are you searching from (which cell), and how are you searching?
    Can you show an example of what you are trying to do?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 12-29-2023, 11:18 AM #5
    jacko1994
    jacko1994 is offline
    Registered User
    Join Date
    12-28-2023
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Mac 16.53
    Posts
    5

    Re: Can't search for data in combined data cell

    Hi,

    Wouldn't let me upload a screen recording

    Please see attached
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  6. 12-29-2023, 03:03 PM #6
    jacko1994
    jacko1994 is offline
    Registered User
    Join Date
    12-28-2023
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Mac 16.53
    Posts
    5

    Re: Can't search for data in combined data cell

    Searching from any free cell in the spreadsheet using Ctrl+F
    Reply With QuoteRegister To Reply
  7. 12-29-2023, 03:04 PM #7
    jacko1994
    jacko1994 is offline
    Registered User
    Join Date
    12-28-2023
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Mac 16.53
    Posts
    5

    Re: Can't search for data in combined data cell

    Help me Obi Wan Kenobi

    You're my only hope
    Reply With QuoteRegister To Reply
  8. 12-29-2023, 03:37 PM #8
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: Can't search for data in combined data cell

    Don't believe that this can be done with Ctl F. Here is a VBA solution 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combined data into 1 cell
    By UltimateNeo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-07-2022, 06:22 AM
  2. [SOLVED] How to convert combined data from one cell (without commas), into rows and columns?
    By gks_19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2022, 10:09 AM
  3. [SOLVED] Combined data in one Cell (TT)
    By aleman_li in forum Excel General
    Replies: 7
    Last Post: 07-22-2019, 11:07 AM
  4. [SOLVED] How to retrieve data from cell when target cell raw/line needs to be combined.
    By Zivhodiva in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2019, 03:07 PM
  5. [SOLVED] Modify formula so that whole cell contents with spaces is combined in search
    By Thintin in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-10-2018, 08:15 AM
  6. Excel wrongly combined numerous data into one cell
    By hd3017 in forum Excel General
    Replies: 1
    Last Post: 01-09-2012, 11:06 PM
  7. [SOLVED] combined cell data from Excel to Word (2003)
    By Adam in forum Excel General
    Replies: 2
    Last Post: 02-14-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1