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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

dglnz

Board Regular
Joined
Apr 30, 2007
Messages
52
Is the report fixed length?

Do you get a wizard appear when you open the file that lets you choose between a fixed length or variable length?

If so choose variable _or_ space seperated/comma file this then puts data into columns, after a couple of screens you have a listbox with what looks like arrows appear (you can move these to define the columns - you can also move 1 on top of the other to remove the line - merge two columns into 1)

Once finish is clicked you get a spreadsheet that has data split into columns.

Now you can Vlookup the data you want on the columns you want.

HTH.

dave

ps will try and do some screen shots for you tomorrow at work tho i'm a bit snowed under at present so it might be somedays before i do this.

to get an idea of what i'm talking about try doing this

this is 1 line of a small report!

column one,column two,column three
data 1,data 2,data3
Row 5, of this,report

***** End of REPORT! *****
 

Forum statistics

Threads
1,181,412
Messages
5,929,782
Members
436,689
Latest member
IbraheemWard

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