| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove first comma in a value
Dear all, I'm having a little trouble with an excel sheet. It consist of 500
plus records with values in it. Because the author of the document it was copied from made some error with placing the decimals I'm now stuck with some cells where there are multiple comma's such as: 78,583,506199 84,831,029277 87,756,172853 10,758,322459 I'm looking for a way to remove the first comma. Find and replace obviously doesn't work because that will replace all the commas . Does anyone know of a way to only remove the first comma ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove comma and text past it in cell | Excel Discussion (Misc queries) | |||
| Remove comma tool bar button | Excel Discussion (Misc queries) | |||
| find and remove a string of a cell value with comma as delimiter | Excel Discussion (Misc queries) | |||
| need to remove a comma from end of test in cells | Excel Worksheet Functions | |||
| How to remove comma and decimals from a value | Excel Discussion (Misc queries) | |||
Threaded Mode
