Re-formatting text to value

I have a data file from LDD (works within AutoCAD) that is giving me information for points along a roadway alignment. One column gives what is called the stationing of the roadway, the format of which has results such as 233+52.23 or 234+20. Sometimes there are numbers after the decimal, sometimes not (implied .00 but it doesn't show up in the text file). Importing into Excel, the stationing becomes text (I imagine because of the "+"). I have converted to a value using the function: =VALUE(SUBSTITUTE(C22,"+","")) where C22 is the location of the imported text. It seems to work just fine.

My question is whether there is another or better way of accomplishing the same thing within EXCEL, or a macro to convert an entire column of stations to values without using two columns for data? Right now, I have a text column and a value column.