F5F Stay Refreshed Software General Software How to locate numerous words in Microsoft Excel 2021?

How to locate numerous words in Microsoft Excel 2021?

How to locate numerous words in Microsoft Excel 2021?

Pages (2): Previous 1 2
I
iRiffleZ
Junior Member
Find
47
11-16-2023, 02:08 PM
#11
I don't understand what "basis" and "output" refer to. The information is about a dataset with several thousand rows.
Reply
Reply
I
iRiffleZ
11-16-2023, 02:08 PM #11

I don't understand what "basis" and "output" refer to. The information is about a dataset with several thousand rows.

Reply
Reply
J
JuJubeTNT
Member
Find
58
11-16-2023, 02:38 PM
#12
I don't get the connection you shared. Could you clarify which details from that link should be applied to your issue?
Reply
Reply
J
JuJubeTNT
11-16-2023, 02:38 PM #12

I don't get the connection you shared. Could you clarify which details from that link should be applied to your issue?

Reply
Reply
C
Cychi
Member
Find
176
11-16-2023, 09:45 PM
#13
The file contains various text entries in different cells. You want to locate specific words or word combinations within it. The purpose behind this is to understand the data better. You could then use that information for further analysis or processing.
Reply
Reply
C
Cychi
11-16-2023, 09:45 PM #13

The file contains various text entries in different cells. You want to locate specific words or word combinations within it. The purpose behind this is to understand the data better. You could then use that information for further analysis or processing.

Reply
Reply
P
Paddy2p
Member
Find
138
11-18-2023, 05:50 AM
#14
I just need to locate that cell and view the data inside it. For instance, previously I entered "John knows how to play the guitar, piano, violin and drum" in an Excel cell. Now I aim to find someone who knows how to play the drum and guitar, so I will look for the terms [drum] [guitar] and this cell will show up allowing me to read the information and confirm John's skills.
Reply
Reply
P
Paddy2p
11-18-2023, 05:50 AM #14

I just need to locate that cell and view the data inside it. For instance, previously I entered "John knows how to play the guitar, piano, violin and drum" in an Excel cell. Now I aim to find someone who knows how to play the drum and guitar, so I will look for the terms [drum] [guitar] and this cell will show up allowing me to read the information and confirm John's skills.

Reply
Reply
P
purplebelt4
Member
Find
61
11-18-2023, 08:25 AM
#15
In the tutorial you referenced, if you need to search for multiple strings within a cell using logic, you can do this in MS Access by linking the Excel file and configuring the Find query to match both "drum" and "guitar". This way, only rows containing both terms will be returned. Utilize the database tools' SQL features rather than manually inputting complex calculations.
Reply
Reply
P
purplebelt4
11-18-2023, 08:25 AM #15

In the tutorial you referenced, if you need to search for multiple strings within a cell using logic, you can do this in MS Access by linking the Excel file and configuring the Find query to match both "drum" and "guitar". This way, only rows containing both terms will be returned. Utilize the database tools' SQL features rather than manually inputting complex calculations.

Reply
Reply
A
Anson1108
Member
Find
102
11-18-2023, 11:25 AM
#16
I do not grasp the connection you shared. Could you clarify which details should be taken from that link for your issue?
Reply
Reply
A
Anson1108
11-18-2023, 11:25 AM #16

I do not grasp the connection you shared. Could you clarify which details should be taken from that link for your issue?

Reply
Reply
Pages (2): Previous 1 2