Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Manage Text In Excel

 

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Convert Text To Numbers, Change Case, Join Text, Remove Spaces & More!

Excel Text Manager

The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.

The Change Case lets you instantly change the case of your text. You can nominate to change your text to:

  • UPPER CASE
  • lower case
  • Proper Case

The Remove Character or Text can save you many hours of manually removing specific characters, or text, from specified text. You can even copy the characters to remove directly from the Windows Character Map. If the character or text you wish to remove is not available, simply check the Specify Character or Text option.

One very common problem with text (particularly imported text) is the unavoidable importing of spaces. Not only does this make your text unsightly and hard to read, but it can also prevent:

  • Numbers not being seen as true numbers.
  • Dates not being seen as true dates.
  • Hard or impossible to break up text.
  • Hard or impossible to reference text.
  • Hard or impossible to use text in formulas.

You can remove all:

  • Leading spaces
  • Trailing spaces
  • Trailing and Leading spaces
  • All spaces, except for single spaces between words.

Have some text you wish to concatenate (link together)? The Text Manager can do this is quickly and easily. Simply specify the cells to concatenate, then specify the cell to concatenate the text into and click OK. Your text will instantly be joined. You can also tell the Text Manager to add a space between each cell that is joined.

 

Text Manager  $29.95 Excel 97 or above | Secure Payment Options | 30 Day Money Back Guarantee & Huge Discounts for Unlimited Licenses Buy on its own or buy as part of the Excel Add-ins Collection for not much more and get our Complete Excel Course for FREE.

Order Type:

Single user license =2 users 2 computers| Unlimited user license = unlimited users unlimited computers | Resellers user license = Do anything you like with the add-in, including rebranding and reselling. That is, NO RESTRICTIONS AT ALL. Please email the support address and include your order number so we can send you the code password. Resellers user license ONLY


Instant Download and Money Back Guarantee on Most Software

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS