Format of cell

[MartinV10]

Hi everyone,
I have question.
I have cell, and I need set the format of this cell to "xxx.xxx.xxx"

X can be letter or number.

And I need seperate that by dots.

Example: 1UA.B20.A40

Iam not able to post workbook.

[Pepe Le Mokko]

You can post a workbook by clicking "Go advanced" - Manage attachments
If your data is too sensitive just mock one up with a few examples

[tranhieu04]

I think you can trim the string, insert "." and join a gaian

[MartinV10]

You can post a workbook by clicking "Go advanced" - Manage attachments
If your data is too sensitive just mock one up with a few examples

Already posted attachment.

[MartinV10]

I think you can trim the string, insert "." and join a gaian

Sorry Iam not understand?

[tranhieu04]

see sample

LEFT(F8,3)&"."&MID(F8,4,3)&"."&MID(F8,7,3)&"."&MID(F8,10,LEN(F8)-9)

[MartinV10]

Ok i will test

[MartinV10]

see sample

LEFT(F8,3)&"."&MID(F8,4,3)&"."&MID(F8,7,3)&"."&MID(F8,10,LEN(F8)-9)

Yeah its working, but we didnt understand each other.
Its not possible to simple set one cell to for "xxx.xxx.xxx"?? Without these tricks.

I just want, that if I copy some stuff there, that automatically format will change to "xxx.xxx.xxx"

[tranhieu04]

so, you can use VBA, with excel formula i think can't solve it. If you want to use VBA i can help
My English so bad....

[Pepe Le Mokko]

@Martin

Administrative Note:

Please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
Use the "Quick reply" instead
Thanks