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?


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

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