Substrings and Rounding in Microsoft Excel

Let’s say I have this number (4.232323456776987654) in Microsoft Excel and I want to round it to two decimal places.
(4.23). How do I do that in Microsoft Excel?

ROUND(4.232323456776987654,2)

Let ‘s say I have this string (afgfgfg-sds) and I just want g-s. How do I do that?

=MID(A1,FIND("-",A1)-1, 3)

Rounding Microsoft Excel
http://office.microsoft.com/en-us/excel-help/round-HP005209239.aspx

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn