VBA to create a column with a formula relative to each row

[ChemistB]

Hi All,
So, the user selects a column within the data that he/she wants to remove a preceeding comma from (sometimes space comma). So I want to create a column to the right of the data with a formula in it to achieve this. This will actually be a series of commands but I figure if I can figure this out, I can get the rest. The formula would be (assuming that Column U is selected)

=TRIM(MID(TRIM(U2),IF(LEFT(TRIM(U2),1)=",",2,1),254))

Here's my code

Please Login or Register  to view this content.

It's not working. I get an error on that last line naturally.
Thanks

[karedog]

Hi ChemistB,

maybe :

Please Login or Register  to view this content.

[ChemistB]

Thanks Karedog, I will test it tomorrow.