Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • When Excel tells you to go get some life Excel User tips
  • Searching table in 2 dimensions. Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Convert cell into textbox Excel User tips
  • Sorting with functions only CHOOSE
  • Looplist – Repeating months using formulas Basic Math
  • Custom fiscal year calendar (CFlex) Basic Math

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

  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Text-to-Columns, dynamically using formulas IFERROR
  • Fixed length ID Formulas - combined functions
  • Cuts string of list of items Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • MATCH fumction, just a simple search Lookup and References

Leave a Reply Cancel reply

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

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Repeated Offset Basic Math
  • CTRL+Y a mini macro Excel User tips
  • State Abbr with Index+Match+Validation Data Validation
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • VLookup Lookup and References
  • Spreadsheet Compare application Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • Excel Functions = XL f(x)s XLfxs

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme