I'm attempting to change the case of a field in an excel file called REC LEN. To do it, I'm using this formula.

`=LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-1) `

This is producing outcomes similar to RecLen. I also want to change the case of my first letter (The expected output is recLen). Can someone please assist me with this? I don't have much experience with Excel formulas. I'm not sure if this has been asked before, but any assistance would be very appreciated.

Nov 19, 2022 in Others 1,719 views

## 1 answer to this question.

Try this:

```=LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_",""),2,LEN(A1))
``` • 63,160 points

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

## An error for excel download in Firefox for JMeter script recording

You shouldn't just copy and paste configuration ...READ MORE

## Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

## How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK(\$C:\$C,\$C2,4),0)) To divide into whichever many ...READ MORE

## =CONCATENATE() function giving a #VALUE! error (EXCEL 2013)

You can use the following: =A1&","&B1 TEXTJOIN would also ...READ MORE

## Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

By right-clicking the Retirement Planner sheet tab ...READ MORE