Remove last character of string does not work

Hello,

I have a macro that generates a string from cell values in cell A4:A999, and seperates them by comma. This works great, but leaves a comma at the end.
I found a solution to removing the comma, but now (after about one week) it does not work anymore.

This is my code:

Please Login or Register  to view this content.

The value pasted in cell I1 is: 3,05860230587633E+300 instead of what i want which is: 3058602,3058763,3059968 etc. Looks like the code removes ALL commas, instead of just the last one.

Any help? As mentioned, it worked for a week.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi, vonrainer,

I would not recommend to use a comma or a point as separator when working with numbers. What happens if you exchange the comma with the pipe sign (|)?

Besides: the code itself will not remove any characters, maybe itīs VBA/Excel which dioes so. And maybe you should alter the code to show the proper tyoe of teh variables that you will use (Option Explicit could be very annoying at the start but proove to be really helpful).

Holger

Hi, vonrainer,

some alternatives. Try using the conversion to a string like

Please Login or Register  to view this content.

See if SQL is accepting a leading apostrophe like

Please Login or Register  to view this content.

Remove the last character when passing the string to SQL. If this is written in VBA code use the pipe sign for the concatening and read the value into a variable and replace the charcters there to see if this would work.

Ciao,
Holger