To reconise text or number

[Steved]

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.

 

[Tim Zych]

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

 

[Steved]

Hello Tim from Steved

Tim thankyou for your script.