Excel How to Insert Values Before or After


 
 

Home
HOME           PRODUCTS           EULA           AFFILIATES           SUPPORT           ABOUT US

Copyright 2014 - 2018 Zbrainsoft.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Home
Insert Text Before Or After In Excel Cells

You can add text before first letter in Excel cell, or after last letter, or add text in certain position, or even add text before 1st uppercase or lowercase. Also you can add serial number to Excel cells such like (1,2,3,4,etc...). Dose for Excel's Add Text utility can save you time and effort adding text in certain positions in a huge Excel worksheets.

  • Click DOSE Text Add Text
Excel Insert Text Before Or After
Excel Insert Text Before Or After
Excel Insert Text Before Or After
  • Add text before first character

1. Select range of cells, and check Before first character option and fill Text box.
2. Then click Apply. In below example we filled Text box with "Microsoft " You will see the result as shown in the below screenshot.
Excel Insert Text Before Or After

Excel Insert Text Before Or After
Excel Insert Text Before Or After
  • Add text after last character

1. Select range of cells, and check After last character option and fill Text box.
2. Then click Apply. In below example we filled Text box with " Excel" You will see the result as shown in the below screenshot.
Excel Insert Text Before Or After

Excel Insert Text Before Or After
Excel Insert Text Before Or After
 
  • Add text in a certain position

1. Select range of cells, and check Specify option and fill Text box.
2. Then click Apply. In below example we filled Text box with "Office " and Specify box with "10" You will see the result as shown in the below screenshot.
Excel Insert Text Before Or After

Excel Insert Text Before Or After
Excel Insert Text Before Or After
 
  • Add text before upercase or lowercase or number

1. Select range of cells, and check "Only add to" option and fill Text box.
2. Then click Apply. In below example we filled Text box with "office " and select 1st letter is uppercase option in "Only add to" dropdown. This will add the text before first occurance of uppercase letter exist in cells. You will see the result as shown in the below screenshot.
Excel Insert Text Before Or After

Excel Insert Text Before Or After
Excel Insert Text Before Or After
 
  • Add serial numbers to cells

1. Select range of cells, and check "SN" option and fill the box.
2. Then click Apply. In below example we filled the SN box with "- ". This will add serial numbers to cells concatenated with symbol "-". You will see the result as shown in the below screenshot.
Excel Insert Text Before Or After

Excel Insert Text Before Or After
Excel Insert Text Before Or After
Dose for Excel

Dose for Excel adds more than +100 new features and functions to your Excel.
Supported Excel versions: 2016, 2013, 2010, 2007 and Office 365. Free download and use for 14 days.

Dose for Excel
Dose for Excel