How to formulate different circuit sizes into one answer.

Alcon, 

(See Sample attached)

I currently have an excel sheet which pulls a report results into Input sheet.

Then formulas within Computations sheet is used to find the correct circuit information including circuit Size. 

In the Results sheet, I am able to create a table with the information.

My problem is that circuit size is showing as 1 Gbps, 45 Mbps, 2.5 Mbps, 10 Gbps...

Is there a formula I can add to Computations or Results sheets so that they are all showing in Mbps?

The After Manual Results sheet contains what I would like the results to look like (Column C).

When doing manually, I simply do a replace all "Mbps" for [blank]. Then another replace all "Gbps" for ",000". 

How can I do the manual step via formula? 

Any assistance is greatly appreciated.