GMayor,


What it did, it went to the last columns and in each cell that had the value ''$'' in it, moved completely the whole cell including the ''$'' to it's Right empty cell. And ignore all other columns.


In my test table (I only used tables of numbers, No text), I have 5 columns of numbers, and every columns has it's empty column besides, to enable to: Cut (the selected value, ...) ''$'', Move 1 Cell unit to the Right, and Paste (the selected value,...) ''$'', Loop to the end.


I just wish my macro I did, would do it all at once, versus, find and replace 1 value at the time.


I wish I could give an example of the test table. How can I insert without having to put a URL link?


Anyway, thanks and if you could think of something... I would be so grateful


I'll try the Guessed suggestion.