Tip Printed from ExcelTip.com

---

Rounding Numerical Substrings


Problem:

Rounding the numbers in the string stored in cell A2 (12.34567<>3.4567) to 3 decimal places.

Solution:

Use the ROUND, LEFT, FIND, and MID functions in the following formula:
=ROUND(LEFT(A2,FIND("<>",A2)-1),3)&"<>"&ROUND(MID(A2,FIND("<>",A2)+2,255),3)