How To Add Hyphen Between Words In Excel Vba
How to add together hyphen between words in Excel?
Generally, we use infinite to separate words in Excel, only now I want to add hyphen symbols between words instead of spaces every bit below screenshot shown. How can y'all apace handle it without removing and adding one by one manually?
Add hyphen between words by Text to Column and formula
Add hyphen betwixt words by Detect and Replace
Add hyphen between words past Kutools for Excel 
The Text to Cavalcade function can separate the words into column based on space, and so you tin can utilise a formula to combine them with hyphen again.
1. Select the data list you want to add hyphens, and click Data > Text to Columns. Run across screenshot:
2. In the first step of Convert Text to Columns wizard, check Delimited pick, and click Next > to footstep 2 of the Wizard, and bank check Infinite option under Delimiters section. Encounter screenshot:
3. Click Next > to get the concluding footstep of the Magician, select a cell to place the split information in Destination textbox. See screenshot:
4. Click Stop. Now the information list has been split into columns, and select a blank jail cell next to the split data, and enter this formula =C1&"-"&D1 (C1 and D1 is the carve up data), and then elevate auto fill handle down to over the cell needed to apply this formula. Encounter screenshot:
Actually, the Find and Replace function also tin speedily supersede spaces with hyphen.
1. Select the information you desire to add hyphen symbols, and press Ctrl + H keys simultaneously to open the Find and Supercede dialog.
two. In the Find and Replace dialog, nether Replace tab, enter a space by space bar to the Discover what textbox, and blazon a hyphen symbol to the Replace with textbox. Run into screenshot:
3. Click Supervene upon Al50. A dialog pops out to remind you how many cells accept been replaced successfully, please click the OK to close it. So far, all spaces accept been replaced with hyphen in the selection. Run into screenshot:
iv. Close the Find and Supercede dialog.
If in some times, there is nothing to divide the words, how can y'all apace add hyphen between words?
With Kutools for Excel, you lot tin utilise its Add Text to add hyphen symbol to the front of every majuscule graphic symbol, and so use the Remove by Position to remove get-go hyphen.
After free installing Kutools for Excel, delight do as below:
1. Select the information yous want to add hyphen, and click Kutools > Text > Add Text. Encounter screenshot:
2. In the Add together Text dialog, enter – into Text box, and then bank check Just add to option, and select Before uppercase letters from the drop downwardly list. Meet screenshot:
three. Click Ok, and the front of each uppercase character has been added hyphen symbol, and click Kutools > Text > Remove past Position. Meet screenshot:
four. In the Remove by Position dialog, enter 1 into Numbers textbox, and check From left under Position department. Meet screenshot:
5. Click Ok, now the hyphen but be added between Words.
The Best Function Productivity Tools
Kutools for Excel Solves Almost of Your Problems, and Increases Your Productivity past fourscore%
- Reuse: Quickly insert circuitous formulas, charts and anything that you have used earlier; Encrypt Cells with password; Create Mailing List and ship emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit big numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split up Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Verbal Copy Multiple Cells without irresolute formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove past Position, Remove Space; Create and Impress Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (salvage and use filter schemes to other sheets); Advanced Sort by month/week/24-hour interval, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on cardinal columns; Split Data into Multiple Sheets; Batch Catechumen xls, xlsx and PDF...
- More than 300 powerful features. Supports Role/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or arrangement. Total features 30-day gratuitous trial. 60-day money back guarantee.
Part Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by fifty%, and reduces hundreds of mouse clicks for you every day!
How To Add Hyphen Between Words In Excel Vba,
Source: https://www.extendoffice.com/94-documents/excel/3743-excel-add-hyphen-between-words.html
Posted by: millswhimen.blogspot.com
0 Response to "How To Add Hyphen Between Words In Excel Vba"
Post a Comment