Home

How do you format cells to input a dash before your text?

%3CLINGO-SUB%20id%3D%22lingo-sub-852871%22%20slang%3D%22en-US%22%3EHow%20do%20you%20format%20cells%20to%20input%20a%20dash%20before%20your%20text%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-852871%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20template%20that%20in%20the%20first%20column%20puts%20a%20dash%20(%20-%20)%20before%20the%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%26nbsp%3B%3C%2FP%3E%3CP%3EHello%26nbsp%3B%20%26nbsp%3B(Input)%3C%2FP%3E%3CP%3E-%20Hello%20(Formatted%20text%20after%20input)%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-852871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-852902%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20format%20cells%20to%20input%20a%20dash%20before%20your%20text%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-852902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408054%22%20target%3D%22_blank%22%3E%40Ilemag625%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EHighlight%20the%20column%3C%2FLI%3E%3CLI%3EPress%20%3CSTRONG%3ECtrl%2B1%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EGo%20to%20Custom%3C%2FLI%3E%3CLI%3EPut%20this%20format%20(%20%3CSTRONG%3E-%20%40%3C%2FSTRONG%3E%20)%20in%20the%20Type%20box%3C%2FLI%3E%3CLI%3EHit%20OK%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131562i1797F3EA7D0EBF2B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-12_20-24-55.png%22%20title%3D%222019-09-12_20-24-55.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-852933%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20format%20cells%20to%20input%20a%20dash%20before%20your%20text%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-852933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20Haytham%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWow!%20That%20was%20fast%2C%20thank%20you%20very%20much%20for%20resolving%20my%20issue!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ilemag625
New Contributor

I am trying to create a template that in the first column puts a dash ( - ) before the text.

 

Example: 

Hello   (Input)

- Hello (Formatted text after input)  

 

Thanks!

2 Replies

@Ilemag625

 

Hi,

 

  • Highlight the column
  • Press Ctrl+1
  • Go to Custom
  • Put this format ( - @ ) in the Type box
  • Hit OK

2019-09-12_20-24-55.png

 

Regards

@Haytham Amairah 

 

Hello Haytham, 

 

Wow! That was fast, thank you very much for resolving my issue!

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies