Reporting Services :: Split Function Resulting In Error

I have a report that is using the following expression for one of the fields:

=Split(Fields!FromAccount.Value, " ")(1)

The format of the number is xxxxx-xxx xxxxxxxxxxxx

So the function is to grab the second section of numbers after the space. The query for this report can bring back 1 to many results which equals one to many pages.

I have an issue where the query returns three results. The first page will display the correct number, the second page displays #Error and the third displays the number.

When I run the query from Management Studio I see the numbers are as follows:

xxxxx-xxx  xxxxxxxxxxxx
xxxxx-xxx xxxxxxxxxxxx
xxxxx-xxx  xxxxxxxxxxxx

Note the first and and last lines have extra spaces which I thought would be the cause of the problem though I would've expected the #Error to appear on the first and third page rather than the second one.

When I remove the extra space for the first and third number all three pages display their values correctly.

However, there are many, many numbers in the table that have one to two spaces. These numbers are from a spreadsheet that is imported biweekly. So it was either I fix the spreadsheet before every import or I come up with a new expression to check for one or two spaces. This is what I came up with:

=IIF (Fields!FromAccount.Value.Contains("  "), Split(Fields!FromAccount.Value, "  ")(1),Split(Fields!FromAccount.Value, " ")(1))

Now, the first page displays the number correctly while the second and third page displays with the #Error. Basically I want to say if the value contains two spaces then split at the two spaces otherwise split at the one space.