lost with column searching

ngkf7

New Member
Joined
Jul 23, 2007
Messages
11
Hi,

I am trying to search a column for a row with specific values. Unfortunately, the data, when taken from the report, is poorly formatted and all in one row. Is there a way to search for a specific substring of the entire row? I have 3 different strings I need to search for in a single row, and this would be much easier than reformatting the report download every day. Case sensitivity is not an issue, since they are mostly strings of numbers.

Thanks
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

QuietRiot

Well-known Member
Joined
May 18, 2007
Messages
1,079
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. MacOS
cant you just add a *

say i wanted to find cat

cat*

will find every instance of it ie; cat123 123cat cat thecat etc
 
Upvote 0

ngkf7

New Member
Joined
Jul 23, 2007
Messages
11
Doing it with an * won't work for what I need to do because I am looking for specific sets of strings. For example, I need to find String1 = ABCDE, String2= 100, String 3 = 200, not ABCDEF, 2100, or 1200. Is there a way to do this? It's unfortunate that this data is all in one column, but I can't change it. Is there not a condition for a "contains" or a substring or anything?
 
Upvote 0

QuietRiot

Well-known Member
Joined
May 18, 2007
Messages
1,079
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. MacOS
ok so you want to find a row

by looking down a column for a cell that contains specific sets of strings

is the data seperated by a space? ABCDE 100 200


*edit*

i think search the entire row it could be any cell but must contain those 3 strings and the 3 strings could be any cell in that row

thats what you mean?
 
Upvote 0

ngkf7

New Member
Joined
Jul 23, 2007
Messages
11
yes exactly. the data is separated by spaces, but not consistent in the number of spaces

ie.
one line can look like:

ABCDE 100 200

and another can look like

ABCDE 100 200
 
Upvote 0

QuietRiot

Well-known Member
Joined
May 18, 2007
Messages
1,079
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. MacOS
yes exactly. the data is separated by spaces, but not consistent in the number of spaces

ie.
one line can look like:

ABCDE 100 200

and another can look like

ABCDE 100 200


will it always be the same cell, same column? just spaced out differently
 
Upvote 0

Forum statistics

Threads
1,191,686
Messages
5,988,067
Members
440,125
Latest member
vincentchu2369

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top