RE: Deleting a Comma ","

You can hilight the column, ctrl+f, ".", then delete all. These will delete
all commas in your column though which you would have to either replace the
first comma or live without it.
Another option is that you could insert another two columns, then in the
first column enter a formula to find the second comma. In the next inserted
column enter a formula to replace the comma with a blank.The formulas would
look something like this:
Inserted column 1 (call it column B):=FIND(",",A1,10)
Inserted column 2 (call it column C):=REPLACE(A1,B1,1,"")
You can then copy your second column (I call it column C) and paste special
"values only" to replace Column A, then delete the inserted Column B & C.

Hope this helps you get started, Good Luck.


"Maracay" wrote:

Hi guys,

Hi have a column with City, Address, Postal Code I need to delete the I
need to delete the “,” between Address and Postal code, the problem is that
is not located in a specific position, some postal codes are longer, some
times there is a space others double space, I want a way to search for that
second comma and deleted,

Thanks

.

Relevant Pages

  • Rick Stanley COMMAS OF THE SECOND
    ... >commas used in the Second Amendment make any difference in its meaning. ... > have seen one of them, and it contained one comma. ... > A grammarian takes issue with a court decision that picks apart clauses of the ... > While the D.C. Circuit Court focused only on the second comma, ...
    (talk.politics.guns)
  • Re: Who will stun the world as next Einstein?
    ... > allowed to insert a comma. ... > and still have correct sentences like this: ... the second comma must be replaced ... He uses the novel punctuation style of replacing *every* full stop ...
    (sci.physics)
  • Re: Who will stun the world as next Einstein?
    ... > allowed to insert a comma. ... > and still have correct sentences like this: ... the second comma must be replaced ... He uses the novel punctuation style of replacing *every* full stop ...
    (sci.physics.relativity)
  • RE: Extracting data for address lists
    ... Returns everyting before that comma ... first comma from that formula we can use that position to find the ... second so now using mid the text between the first and second comma can be ... address in a cell, separated by commas, I need to take the data before the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Formatting...
    ... Not sure I follow you completely but to kill everything from the first comma ... Now when I run the script the output is like this: ... How can I kill these extra commas? ...
    (microsoft.public.scripting.vbscript)
Quantcast