Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Zipcode-State search Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • Dynamic selection list ActiveX controls
  • Week number to Sunday date – Weeknum reverse DATE
  • New function IFERROR, finally IFERROR
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Count cells with condition – multiple conditions COUNTIFS
  • Text-to-Columns, dynamically using formulas IFERROR

CamelCase to Camel Case

Posted on January 26, 2012 By ANmar No Comments on CamelCase to Camel Case

Here is a good practice for combining functions to get a full smartsheet

It basically add a space before any capital letter in a text, helpful when you have strings without spaces and want to convert them.

It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request. Uses functions LEFT, MID, FIND, SMALL, COUNT, COLUMN, IF, CHAR, ISERROR, TRIM

I used here three formulas, first one in column C:

=TRIM(LEFT(B4,AE4-1)&" "&MID(B4,AE4,IF(AF4="",500,AF4-AE4))&" "&IF(N(AF4)>0,MID(B4,AF4,IF(AG4="",500,AG4-AF4)),"")&" "&IF(N(AG4)>0,MID(B4,AG4,IF(AH4="",500,AH4-AG4)),""))

And another one for columns E through AD:

=IF(ISERROR(FIND(CHAR(COLUMN()+60),$B4,1)),"",FIND(CHAR(COLUMN()+60),$B4,1))

And a third one in columns AE through AH

=IF(COUNT($D4:$AD4)>=COLUMN()-29,SMALL($D4:$AD4,COLUMN()-29),"")

 

CHAR, FIND, Formulas - combined functions, IF, Information, ISERROR, Logical, Math and Trig, MID, SMALL, Standard functions, Texts and Strings, TRIM

Post navigation

Previous Post: Sum of divide – Array formula
Next Post: Tally chart in functions

Related Posts

  • OFFSET+MATCH Formulas - combined functions
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Week number to Month number DATE
  • Count cells with condition – multiple conditions COUNTIFS
  • Text-to-Columns, dynamically using formulas IFERROR
  • CHOOSE – tree of decisions CHOOSE

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Recover the unrecoverable Excel User tips
  • New function IFERROR, finally IFERROR
  • iframe in Excel (XLiFrame) ADDRESS
  • The Excel “&” bug Excel User tips
  • Excel Functions = XL f(x)s XLfxs
  • DayName Date and Time
  • Searching table in 2 dimensions. Formulas - combined functions
  • 6174 Kaprekar’s constant Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme