Are you stuck on Excel or Google Sheets?

How can I change the first letter in a string of data like shown below - so that it is lower case in each string. The data is already in excel- each example shown below would need a lower case B (b) - and are presented in the same column, different rows. Nothing else should changed just B to b - I need to do this on many sheets, so I need a formula. The data is different on each sheet, but the same issue. Thank you. BJHS3134 BJHS3170 BJHS2819 BJHS3295 BJHS3822 BJHS3258 BJHS3365 BJHS3417 BJHS3226 BJHS4315

I am trying to make a format rule that when a cell in column E is equal to the adjacent cell in column D, it will highlight green, unless both columns are blank.

using excel as a checkbook -- formula =IF(ISBLANK(E283),"",N282-J283+L283) after 280 lines it is now just saying VALUE in the balance column (N) What have I done wrong?

I need to delete additive inverse of numbers. For eg. column A contains value 234 and -234. How to delete both values from a large dump of numbers?

i want my spreadsheet to update stocks on the stocks column automatically from links provided in column and display the stock status on third column.

Hi, I wish to create a chart which row a, column a is say a value of 5, row b column a is a value of 5, but row c column a is a value of 6 (incrementing every 2 cells)

column k is the sum of column f x column j

I need a formula to combine column C with the number mentioned in column L26 to L32

I need a column to total (Hours)(85) + (Travel)(.55) per line

I have a numeric identifier in column A with a corresponding numeric value (Let's call it Z) X columns below it. There are varying duplicated cells of the identifier before Z I also have a numeric value (Y) in Column B that I am trying to verify is the same value as Z. Is there a way to scan down Column A, identify Z, and match it to Y?