Home

how to change the postion of delimiter in the cell. (PLEASE SEE ATTACHMENT)

%3CLINGO-SUB%20id%3D%22lingo-sub-921786%22%20slang%3D%22en-US%22%3Ehow%20to%20change%20the%20postion%20of%20delimiter%20in%20the%20cell.%20(PLEASE%20SEE%20ATTACHMENT)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-921786%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20big-size%20Excel%20file.%20as%20seen%20in%20attached%20file%2C%20i%20Need%20to%20put%20delimiter%20(dot%20or%20comma)%20after%20the%20first%20second%20number.%20i%20ask%20for%20your%20quick%20responce%20with%20effective%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAGAIN%3A%20i%20would%20like%20to%20put%20only%20one%26nbsp%3Bdot%20after%20the%20first%20second%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-921786%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-922079%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20change%20the%20postion%20of%20delimiter%20in%20the%20cell.%20(PLEASE%20SEE%20ATTACHMENT)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-922079%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F430029%22%20target%3D%22_blank%22%3E%40mtopan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECouldn't%20see%20an%20attachment%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20say%20first%20second%20number%20I'm%20not%20sure%20what%20you%20mean%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20be%20able%20to%20use%20something%20like%20this%26nbsp%3B%20%26nbsp%3B%3DLEFT(A1%2C2)%26amp%3B%22.%22%26amp%3BRIGHT(A1%2CLEN(A1)-2)%3C%2FP%3E%3C%2FLINGO-BODY%3E
mtopan
Occasional Visitor

I have a big-size Excel file. as seen in attached file, i Need to put delimiter (dot or comma) after the first second number. i ask for your quick responce with effective help.

 

AGAIN: i would like to put only one dot after the first second number.

1 Reply

Hi @mtopan 

 

Couldn't see an attachment

 

When you say first second number I'm not sure what you mean

 

You may be able to use something like this   =LEFT(A1,2)&"."&RIGHT(A1,LEN(A1)-2)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies