You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Conditional caps to lowercase

Conditional caps to lowercase

Price: FREE

Example security identifiers:
ABC EQUITY
ABC INDEX
ABC COMDTY
ABC CURNCY
Is there a way to convert everything but the first letter in the second word to lowercase using some form of the LOWER function?
ABC Equity
ABC Index
ABC Comity
ABC Curacy
This would be very helpful if I can figure this out.

Visit publisher's web-site: Conditional caps to lowercase

Category and Tags: ExcelTutorials :

Related Tutorials

UPPERCASE to lowercase

Free: Yes
Tags: Excel ›

We have an export that is roughly 3,00 rows. In column A, customer names, export is in ALL CAPS. We want to change from ALL CAPS to normal formatting.
ie:
KAUAI FRESH FARMS to Kauai Fresh Farms
ROBERT TORNELLO to Robert Cornelle
We are trying to do this without retyping the data in each cell. Any quick fixes?

Upper to Lowercase in Excel

Free: Yes
Tags: Excel › Functions

I have a spreadsheet with first and last name (column A), address 1 (column B), address 2 (column C), City (column D), State (column E), Zip (column F). All text is in uppercase. Is there a way to update all columns to In ital Caps (upper/lower case)

Filtering on upper/lowercase letters

Free: Yes
Tags: Excel ›

In Excel 2007, I have several records that contain both uppercase and lowercase letters in two columns. I need to create a filter so that ONLY the records containing lowercase letters are displayed. I don't need to convert the case, I only need to see which records contain lowercase. Haven't been able to come up with anything on my own.

Creating Drop Caps in CSS

Free: Yes
Tags: CSS › Excel Advanced Techniques

Drop caps are a very useful technique for making your paragraphs stand out a bit. Today, we'll have a look at how to implement drop caps with care, and some of the pitfalls surrounding their use.

How do I set all caps as the default?

Free: Yes
Tags: Excel › Functions

I want to set my worksheet up so that all text entered is in caps. I do not want to have to toggle the Caps Lock key to do this. Is there a way to make

Related Applications & Scripts

Pixel Block Text PRO AS2

Free: No

Block Text with rotating pixel cubes creating letters and numbers. Uppercase, Lowercase, special characters.
Offering mirror, filters, 3D/non-3D letters and multicolor options. All letters are array-defined combinations in a 14 x 6 rectangle grid. Any shape can be defined within the grid dimension.
Main new features include:
- Rotation around its own axis for each block created out of a 12 keyframe sequence;
- Option to add a mirror reflection to letters;
- More characters: Uppercase and Lowercase, common special
- characters and ? ! !! $
- and you can always create your own characters in a 14x6 grid;
- Use 3D letters or on-3D (flat) letters;
- Add filters, including glow, bevel, blurX and blurry;
- Multiple colors(tints) possible for the blocks in each letter;
- Add customizable rotating flares and shining lights to letters;
- Choose different acceleration options and different block matching movements.

my NewsTicker

Free: No
Tags: Flash › Excel News Readers

An easy to manage, xml-based news ticker for your sites.
Features:
- pause time
- maximum character to prevent loooong headlines to ruin your layout ;p
- set headlines to uppercase or lowercase
- and of course unlimited entry of news

my News Ticker (RSS)

Free: No
Tags: Flash › Excel News Readers

An easy to manage, XML /RSS news ticker for your sites.
Features:
* pause on rollover
* maximum character to prevent loooong headlines
* set headlines to uppercase or lowercase
* default pause time
* next&prev buttons to skip through

Pixel Block Text PRO AS3

Free: No
Tags: Flash › Excel Text Effects

New version of Pixel Block Text. All letters are array-defined combinations in a 14 x 6 rectangle grid. Any shape can be defined within the grid dimension.
Main new features include:
- Rotation around its own axis for each block created out of a 12 keyframe sequence;
- Option to add a mirror reflection to letters;
- More characters: Uppercase and Lowercase, common special...

Wooden Font + text effects

Free: No

Enough of those boring fonts? Use this Wooden Typo for a cool look! Try the Wooden font previewer! Replace the ActiveDen text with yours, try some cool settings and press the PLAY button!
Every lowercase/uppercase character, all numbers and punctuations. All characters are vector, so fully scalable. Use uppercase characters for a nice leave effect!

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing