| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove first comma in a value
I tried you solution and this is the best solution. Gary''s Student's
solution was good but gave error on values without a comma. Your solution just ignores the values without comma and just shows the original value. Thanks a lot, all of you. You've been a great help. "Jacob Skaria" wrote: Hi John =REPLACE(A1,3,1,"") will work only if the comma is in the third position Use the below formula with SUBSTITUTE() which will always remove the first comma..in which ever position.... =SUBSTITUTE(A1,CHAR(44),,1) If this post helps click Yes --------------- Jacob Skaria "JohnBlack" wrote: 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
