SoftMaker.com

Hi

When opening text files, you can specify the field format as either "Separator between fields" or "Fixed field widths".

But how do you specify the width of each field?
I would expect to be able to say character 1 to 20 would go to Column 1, character 22 to 50 to Column 2 etc. All you can work ...

Why do you return #VALUE! error value from Search function instead of 0 when the value is not found in the string?

A value not being found in a string is IMO not an error situation - it is a perfectly valid result. You do not see the text search functions in .NET throwing exceptions because the ...