If that is the only space you can use Find and Replace
Enter a blank in FIND What
and nothing in REPLACE With

Select the range you want to update and press CTRL-H
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Calculate Date range" wrote:

I need to remove the spacing in between comma and capital L

Chan, Lucy-CS

Can anyone help me on this

Thanks.