Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reformatting Cells
I have this in my column:
858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 858+00.000 R 2 859+00.000 R 2 859+00.000 R 2 859+00.000 R 2 859+00.000 R 2 859+00.000 R 2 etc.. This progresses all the way to 1350+00 R 2. All I want to do is remove the R 2 at the end, but keep the number. There must be a faster way than deleting the R 2 in the formula toolbar, then copypaste in my column. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformatting | Excel Discussion (Misc queries) | |||
Excel 2007 reformatting cells | Excel Discussion (Misc queries) | |||
Reformatting numbers in cells | New Users to Excel | |||
Reformatting text in cells | Excel Worksheet Functions | |||
Macro for reformatting cells | Excel Worksheet Functions |