inserting a dot between numbers in cells

[manickmj]

I need to insert a dot between numbers when I convert warehouse locations to an excel spreadsheet.

when I convert to excel it comesout like this: 3581001a5 but I need it to sepetate with a dot like this : 35.81.001.a5

Is this possible with a formula? I can send you a attachment if needed.

Thanks in advance

[Glenn Kennedy]

Can you post an Excel sheet, showing representative examples, unless the data ALWAYS organised as 2 digits DOT 2 digits DOT 3 digits DOT 2 digits??

Are they??


Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

[ExcelFixer]

Assuming your data is in a1 then:

Please Login or Register  to view this content.

[Glenn Kennedy]

If they DO ALWAYS follow that pattern, try this:

=LEFT(A1,2)&"."&MID(A1,3,2)&"."&MID(A1,5,3)&"."&RIGHT(A1,2)

[manickmj]

Thanks you guys are awesome!!!

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.