macro delete first three symbols

[Paradi]

51U Black Cloth Headliner
731 Burl Walnut Wood Trim
P17 Keyless-Go

<tbody>
</tbody>

Hi,

I couldn't find good macros to delete firs three symbols from cell (51U, 731, ).. its not always the same symbols... I was trying a lot off different macros and always something is wrong any idea?



I kwon the formula (=right(a1,len.....) and its work, but I need macros because I partly remove the cells and later I all these cells separate using commas.


Please help me create a macro to remove the 3 first symbols

 

[Peter_SSs]

I have another question:
When I separate comma my text I don't have a space after the comma. I know than I could use "trim(substitute...." option by macros would be much better

I don't think that I understand your question. If you want a space after the comma then just put one there.

outStr = outStr & ", " & rng.Value

If that is not what you mean then please give a clearer description and a small set of dummy sample data and the expected output.

BTW, when posting code you need to use CODE tags to preserve the formatting, not QUOTE tags