To reconise text or number
 

Hello from Steved

4284 640 "Both worksheets have the same information in both columns

Ok whats my issue
I import A "Oracle file" into my spreadsheet the below formula is not
working, now if I copy "4284 and "640" into the imported worksheet it works.
I know "+0" sees text and treats it as a number, my question is their
something similar please.
=INDEX(Timetables!$F$2:$F$5000,MATCH(1,(Timetables !$E$2:$E$5000=B71)*(Timetables!$D$2:$D$5000=C71),0 ))

Thankyou.

To reconise text or number
 

You might need to "scrub" the imported data. After the import you can run
this macro to clean things up a bit, and then formulas should be more
responsive.

Activate the imported-data sheet first...

Sub CleanData()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange.Cells
cell.Value = cell.Value
' Or optionally trim fixed-length strings
' cell.Value = Trim(cell.Value)
Next
End Sub


--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

"Steved" wrote in message
...
Hello from Steved

4284 640 "Both worksheets have the same information in both columns

Ok whats my issue
I import A "Oracle file" into my spreadsheet the below formula is not
working, now if I copy "4284 and "640" into the imported worksheet it
works.
I know "+0" sees text and treats it as a number, my question is their
something similar please.
=INDEX(Timetables!$F$2:$F$5000,MATCH(1,(Timetables !$E$2:$E$5000=B71)*(Timetables!$D$2:$D$5000=C71),0 ))

Thankyou.

To reconise text or number
 

Hello Tim from Steved

Tim thankyou for your script.

"Tim Zych" wrote:

You might need to "scrub" the imported data. After the import you can run
this macro to clean things up a bit, and then formulas should be more
responsive.

Activate the imported-data sheet first...

Sub CleanData()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange.Cells
cell.Value = cell.Value
' Or optionally trim fixed-length strings
' cell.Value = Trim(cell.Value)
Next
End Sub


--
Regards,
Tim Zych
http://www.higherdata.com
Workbook Compare - Excel data comparison utility

"Steved" wrote in message
...
Hello from Steved

4284 640 "Both worksheets have the same information in both columns

Ok whats my issue
I import A "Oracle file" into my spreadsheet the below formula is not
working, now if I copy "4284 and "640" into the imported worksheet it
works.
I know "+0" sees text and treats it as a number, my question is their
something similar please.
=INDEX(Timetables!$F$2:$F$5000,MATCH(1,(Timetables !$E$2:$E$5000=B71)*(Timetables!$D$2:$D$5000=C71),0 ))

Thankyou.