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.
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.
Last edited by MartinV10; 08-15-2019 at 03:07 AM.
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
I think you can trim the string, insert "." and join a gaian
see sample
LEFT(F8,3)&"."&MID(F8,4,3)&"."&MID(F8,7,3)&"."&MID(F8,10,LEN(F8)-9)
Ok i will test
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....
@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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks