Copy and change format cell?

[MartinV10]

I have a question, is it possible to simply copy something and then paste that values in concrete format (xxx.xxx.xxx)/3symbols.3symbols.3symbols by macro?

In attachment is preview what I need.

Or by macro change the format of cells it would be the best.


Start macro and format cells will change to (xxx.xxx.xxx).
X can be letter or number.

And I need seperate that by dots.

Example: 1UA.B20.A40

Thanks for any advice.

[Pepe Le Mokko]

This post looks a lot like your precedent one ? https://www.excelforum.com/excel-gen...ml#post5177011

[MartinV10]

@Pepe Le Mokko it was in other group. I thought its possible to do that by simple function. Now I wanna VBA code? So I changed group? Is it false?

[Pepe Le Mokko]

As you are willing to go the macro way, it's OK.
Perhaps add a link to this thread in your other one with a short explanation to avoid confusion ?

[Marc L]

According to the attachment as a starter :

Sub Demo1() 
    With [E8] 
        .Value2 = Format(.Value2, Application.Rept("@@@.", Len(.Value2) \ 3)) 
    End With 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » !