=LEFT(A1,LEN(A1)-2)&"."&RIGHT(A1,2)
=LEFT(A1,LEN(A1)-2)&"."&RIGHT(A1,2)
it adds a "." 3 characters in from the right
Title | # Comments | Views | Activity |
---|---|---|---|
How can I modify this Excel worksheet with a script? | 15 | 43 | |
MS Excel "--" in Formula What is it doing? | 3 | 12 | |
Excel split data and output all combinations. | 2 | 16 | |
Need custom function to combine cells in Excel 2010 | 3 | 13 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!