Data entry shortcuts for copying and pasting into other Apps

%3CLINGO-SUB%20id%3D%22lingo-sub-2589280%22%20slang%3D%22en-US%22%3EData%20entry%20shortcuts%20for%20copying%20and%20pasting%20into%20other%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2589280%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22kvgmc6g5%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3EI've%20forgotten%20the%20data%20entry%20shortcuts%20for%20copying%20and%20pasting%20into%20other%20Apps.%3C%2FDIV%3E%3CDIV%3EA%20few%20years%20ago%20I%20had%20a%20spreadsheet%20set%20up%20to%20enter%20in%20Excel%2C%20which%20I%20could%20then%20use%20to%20copy%20and%20paste%20into%20another%20App%20(Xero)%20where%20I%20added%20special%20characters%20in%20one%20column%20to%20denote%20TAB%20and%20more%20special%20characters%20in%20another%20column%20to%20denote%20ENTER%2C%20which%20was%20something%20like%20%5E%25%20or%20~%5E%2C%20does%20anyone%20know%20what%20these%20are%3F%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22o9v6fnle%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3EThis%20isn't%20a%20simple%20ctrl%20c%2C%20ctrl%20p.%20It's%20for%20taking%20the%20place%20of%20'tab'%20and%20'enter'%20so%20that%20a%20list%20of%20data%20can%20be%20copied%20and%20pasted%20from%20Excel%20into%20another%20app%20(Xero)%20in%20one%20go%2C%20whereas%20if%20I%20would%20have%20to%20copy%20and%20paste%20one%20cell%20at%20a%20time%20if%20I%20used%20ctrl%20c%2C%20ctrl%20p%20to%20enter%20data%20into%20another%20app%20one%20item%20at%20a%20time%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22o9v6fnle%20cxmmr5t8%20oygrvhab%20hcukyx3x%20c1et5uql%20ii04i59q%22%3E%3CDIV%3ESo%20in%20my%20example%20attached%2C%20I%20would%20select%20cells%20A2%20to%20C3%20in%20Excel%2C%20and%20paste%20it%20into%20the%20other%20app%20(Xero)%20and%20it%20would%20populate%20many%20rows%2C%20except%20I%20forgotten%20the%20characters%20that%20would%20take%20the%20place%20of%20tab%20and%20enter!%20Please%20help!%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2589280%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647902%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20entry%20shortcuts%20for%20copying%20and%20pasting%20into%20other%20Apps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1113234%22%20target%3D%22_blank%22%3E%40SarahJacobs22%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1628926038904.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303249i94654E98B2AC8A4C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1628926038904.png%22%20alt%3D%22Yea_So_0-1628926038904.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_1-1628926086356.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303250i447D3D02B6F32B84%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_1-1628926086356.png%22%20alt%3D%22Yea_So_1-1628926086356.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fworking-with-excel-4-0-macros-ba8924d4-e157-4bb2-8d76-2c07ff02e0b8%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWorking%20with%20Excel%204.0%20macros%20-%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fd13ot9o61jdzpp.cloudfront.net%2Ffiles%2FExcel%25204.0%2520Macro%2520Functions%2520Reference.pdf%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%204.0%20Macro%20Functions%20Reference%20(d13ot9o61jdzpp.cloudfront.net)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I've forgotten the data entry shortcuts for copying and pasting into other Apps.
A few years ago I had a spreadsheet set up to enter in Excel, which I could then use to copy and paste into another App (Xero) where I added special characters in one column to denote TAB and more special characters in another column to denote ENTER, which was something like ^% or ~^, does anyone know what these are?
This isn't a simple ctrl c, ctrl p. It's for taking the place of 'tab' and 'enter' so that a list of data can be copied and pasted from Excel into another app (Xero) in one go, whereas if I would have to copy and paste one cell at a time if I used ctrl c, ctrl p to enter data into another app one item at a time
So in my example attached, I would select cells A2 to C3 in Excel, and paste it into the other app (Xero) and it would populate many rows, except I forgotten the characters that would take the place of tab and enter! Please help!
1 Reply