SOLVED
Home

HOW TO: Report a portion of a string of text (i.e. characters 4-6) from another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-486384%22%20slang%3D%22en-US%22%3EHOW%20TO%3A%20Report%20a%20portion%20of%20a%20string%20of%20text%20(i.e.%20characters%204-6)%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486384%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20determine%20how%20to%20write%20a%20formula%20to%20pull%20specific%20characters%20from%20a%20text%20cell%26nbsp%3Band%20populate%20a%20new%20text%20cell.%26nbsp%3B%20For%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20contains%20the%20full%20text%20string%20(22%20characters%20in%20total)%20and%20I%20would%20like%20column%20B%20to%20report%20characters%208%20and%209%2C%20add%20a%20%22%2F%22%2C%20and%20then%20characters%2010%20and%2011%2C%20add%20a%20%22-%22%2C%20and%20then%20characters%2012%20and%2013)%3C%2FP%3E%3CP%3EEx%3A%20Column%20A%20%3D%20SK%20WI%201%3CSTRONG%3E020122%3C%2FSTRONG%3E00315W200%20and%20I%20want%20Column%20B%20to%20%3D%2002%2F01-22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance!%3C%2FP%3E%3CP%3ECarly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-486384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486448%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%3A%20Report%20a%20portion%20of%20a%20string%20of%20text%20(i.e.%20characters%204-6)%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328307%22%20target%3D%22_blank%22%3E%40carlos2250%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Carly%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DREPLACE(REPLACE(MID(A1%2C8%2C6)%2C3%2C%2C%22%2F%22)%2C6%2C%2C%22-%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486801%22%20slang%3D%22en-US%22%3ERe%3A%20HOW%20TO%3A%20Report%20a%20portion%20of%20a%20string%20of%20text%20(i.e.%20characters%204-6)%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486801%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20Sergei%20-%20that's%20perfect.%3C%2FP%3E%3C%2FLINGO-BODY%3E
carlos2250
New Contributor

Hello,

 

I am trying to determine how to write a formula to pull specific characters from a text cell and populate a new text cell.  For example:

 

Column A contains the full text string (22 characters in total) and I would like column B to report characters 8 and 9, add a "/", and then characters 10 and 11, add a "-", and then characters 12 and 13)

Ex: Column A = SK WI 102012200315W200 and I want Column B to = 02/01-22 

 

Thanks in Advance!

Carly

3 Replies
Solution

@carlos2250 

 

Hi Carly,

 

That could be 

=REPLACE(REPLACE(MID(A1,8,6),3,,"/"),6,,"-")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies