“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Can't figure out if I need to be using Countifs formula and counta formula or one or the other to count cells with numbers and letters

Solved by F. E. in 29 mins

I have a row of letters and numbers i need to remove the letters and add them to another column. Example BSN17525

Solved by V. Q. in 28 mins

Hello, I need check the format of a cell I need it to return the following logic: IF the first two letters in column E = GB AND has 9 numbers are the two letters then that should return correct. OR IF the first two letters in column E = FR AND has 11 numbers are the two letters then that should return correct. OR IF the first two letters in column E = DE AND has 9 numbers are the two letters then that should return correct. SO the the logic is IF left and len is number.

Solved by T. J. in 30 mins

Hi there, i would like to create a column with initial letters in capital letters and seperated by . (Dot)

Solved by Z. F. in 24 mins

i want to get rid of letters from a combination of numbers and letters and but values with a specific letter i want to be negative and the rest positive

Solved by B. J. in 22 mins