Hoping someone can offer some help. I have a report I exported into Excel 2010. When the report came over, commas appeared at the end of each date. I need the comma removed. I have tried several different formulas I have found in various searches and none seem to work.
Here is a sample of my worksheet: This worksheet can have hundreds or thousands of rows all with different dates, so I'm looking for an easy solution to remove the end comma from the date. The date column will always be column "D".
[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Name
[/TD]
[TD="width: 64, bgcolor: transparent"]Acct
[/TD]
[TD="width: 64, bgcolor: transparent"]Class
[/TD]
[TD="width: 64, bgcolor: transparent"]Date
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]11111
[/TD]
[TD="width: 64, bgcolor: transparent"]AAA
[/TD]
[TD="width: 64, bgcolor: transparent"]03/02/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]22222
[/TD]
[TD="width: 64, bgcolor: transparent"]BBB
[/TD]
[TD="width: 64, bgcolor: transparent"]03/02/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]33333
[/TD]
[TD="width: 64, bgcolor: transparent"]CCC
[/TD]
[TD="width: 64, bgcolor: transparent"]03/09/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]44444
[/TD]
[TD="width: 64, bgcolor: transparent"]DDD
[/TD]
[TD="width: 64, bgcolor: transparent"]03/09/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]55555
[/TD]
[TD="width: 64, bgcolor: transparent"]EEE
[/TD]
[TD="width: 64, bgcolor: transparent"]03/14/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]66666
[/TD]
[TD="width: 64, bgcolor: transparent"]FFF
[/TD]
[TD="width: 64, bgcolor: transparent"]03/15/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]77777
[/TD]
[TD="width: 64, bgcolor: transparent"]GGG
[/TD]
[TD="width: 64, bgcolor: transparent"]03/15/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]88888
[/TD]
[TD="width: 64, bgcolor: transparent"]HHH
[/TD]
[TD="width: 64, bgcolor: transparent"]03/16/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]99999
[/TD]
[TD="width: 64, bgcolor: transparent"]III
[/TD]
[TD="width: 64, bgcolor: transparent"]03/13/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]12345
[/TD]
[TD="width: 64, bgcolor: transparent"]JJJ
[/TD]
[TD="width: 64, bgcolor: transparent"]03/12/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]23456
[/TD]
[TD="width: 64, bgcolor: transparent"]KKK
[/TD]
[TD="width: 64, bgcolor: transparent"]03/21/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]34567
[/TD]
[TD="width: 64, bgcolor: transparent"]LLL
[/TD]
[TD="width: 64, bgcolor: transparent"]03/23/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]45678
[/TD]
[TD="width: 64, bgcolor: transparent"]MMM
[/TD]
[TD="width: 64, bgcolor: transparent"]03/20/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]56789
[/TD]
[TD="width: 64, bgcolor: transparent"]NNN
[/TD]
[TD="width: 64, bgcolor: transparent"]03/23/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]67890
[/TD]
[TD="width: 64, bgcolor: transparent"]OOO
[/TD]
[TD="width: 64, bgcolor: transparent"]03/20/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]78901
[/TD]
[TD="width: 64, bgcolor: transparent"]PPP
[/TD]
[TD="width: 64, bgcolor: transparent"]03/27/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]89012
[/TD]
[TD="width: 64, bgcolor: transparent"]QQQ
[/TD]
[TD="width: 64, bgcolor: transparent"]03/29/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]90123
[/TD]
[TD="width: 64, bgcolor: transparent"]RRR
[/TD]
[TD="width: 64, bgcolor: transparent"]03/30/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]98765
[/TD]
[TD="width: 64, bgcolor: transparent"]SSS
[/TD]
[TD="width: 64, bgcolor: transparent"]03/30/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]87654
[/TD]
[TD="width: 64, bgcolor: transparent"]TTT
[/TD]
[TD="width: 64, bgcolor: transparent"]03/29/18,
[/TD]
[/TR]
</tbody>[/TABLE]
I appreciate any help you can give!
Here is a sample of my worksheet: This worksheet can have hundreds or thousands of rows all with different dates, so I'm looking for an easy solution to remove the end comma from the date. The date column will always be column "D".
[TABLE="width: 192"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Name
[/TD]
[TD="width: 64, bgcolor: transparent"]Acct
[/TD]
[TD="width: 64, bgcolor: transparent"]Class
[/TD]
[TD="width: 64, bgcolor: transparent"]Date
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]11111
[/TD]
[TD="width: 64, bgcolor: transparent"]AAA
[/TD]
[TD="width: 64, bgcolor: transparent"]03/02/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]22222
[/TD]
[TD="width: 64, bgcolor: transparent"]BBB
[/TD]
[TD="width: 64, bgcolor: transparent"]03/02/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]33333
[/TD]
[TD="width: 64, bgcolor: transparent"]CCC
[/TD]
[TD="width: 64, bgcolor: transparent"]03/09/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]44444
[/TD]
[TD="width: 64, bgcolor: transparent"]DDD
[/TD]
[TD="width: 64, bgcolor: transparent"]03/09/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]55555
[/TD]
[TD="width: 64, bgcolor: transparent"]EEE
[/TD]
[TD="width: 64, bgcolor: transparent"]03/14/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]66666
[/TD]
[TD="width: 64, bgcolor: transparent"]FFF
[/TD]
[TD="width: 64, bgcolor: transparent"]03/15/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]77777
[/TD]
[TD="width: 64, bgcolor: transparent"]GGG
[/TD]
[TD="width: 64, bgcolor: transparent"]03/15/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]88888
[/TD]
[TD="width: 64, bgcolor: transparent"]HHH
[/TD]
[TD="width: 64, bgcolor: transparent"]03/16/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]99999
[/TD]
[TD="width: 64, bgcolor: transparent"]III
[/TD]
[TD="width: 64, bgcolor: transparent"]03/13/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]12345
[/TD]
[TD="width: 64, bgcolor: transparent"]JJJ
[/TD]
[TD="width: 64, bgcolor: transparent"]03/12/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]23456
[/TD]
[TD="width: 64, bgcolor: transparent"]KKK
[/TD]
[TD="width: 64, bgcolor: transparent"]03/21/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]34567
[/TD]
[TD="width: 64, bgcolor: transparent"]LLL
[/TD]
[TD="width: 64, bgcolor: transparent"]03/23/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]45678
[/TD]
[TD="width: 64, bgcolor: transparent"]MMM
[/TD]
[TD="width: 64, bgcolor: transparent"]03/20/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]56789
[/TD]
[TD="width: 64, bgcolor: transparent"]NNN
[/TD]
[TD="width: 64, bgcolor: transparent"]03/23/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]67890
[/TD]
[TD="width: 64, bgcolor: transparent"]OOO
[/TD]
[TD="width: 64, bgcolor: transparent"]03/20/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]78901
[/TD]
[TD="width: 64, bgcolor: transparent"]PPP
[/TD]
[TD="width: 64, bgcolor: transparent"]03/27/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]89012
[/TD]
[TD="width: 64, bgcolor: transparent"]QQQ
[/TD]
[TD="width: 64, bgcolor: transparent"]03/29/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]90123
[/TD]
[TD="width: 64, bgcolor: transparent"]RRR
[/TD]
[TD="width: 64, bgcolor: transparent"]03/30/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]98765
[/TD]
[TD="width: 64, bgcolor: transparent"]SSS
[/TD]
[TD="width: 64, bgcolor: transparent"]03/30/18,
[/TD]
[/TR]
[TR]
[TD="width: 64, bgcolor: transparent"]last, first
[/TD]
[TD="width: 64, bgcolor: transparent"]87654
[/TD]
[TD="width: 64, bgcolor: transparent"]TTT
[/TD]
[TD="width: 64, bgcolor: transparent"]03/29/18,
[/TD]
[/TR]
</tbody>[/TABLE]
I appreciate any help you can give!