lenght

I need some formulas to extract a certain part of the text from the main cell. I just can't think of a logical way to do that because using Left and Right will not work as the texts differ in lenght. https://ibb.co/cv3NQxx The columns B, C, D and E should give those small extracts from the...

Morning I have a list of names in column A lets say wood types I have a lenght in column B I have a quantity in column C in column A a wood type could appear mulltiple instances. like below. oak 2000 1 beech 2000 3 oak 1000 2 pine 3000 6 oak 50...

Hi I have a requirement where I need to check the length of cell value in 2 ranges (eg. column A to Last row & column E to Last row) and also detect if a specific range in column is empty in about 60 files in a folder. length (column a) should be exactly 32 characters long length (column e)...

Hi everyone, I have a VBA code puzzle to solve. I want to reverse an alphanumeric string, but reverse only letters and leave digits where they are. So for example: abc123dfg ---> gfd123cba 451ubno98p ---> 451ponb98u egc88rtv972nq100 ---> qnv88trc972ge100 Do you have any ideas? Probably I...

Hi, How to extract just the text highlighted in red color (the required text could have variable lenght) R$ 47,15 em 23/07/18 as 18:34 BELA VITORIA Regards,

I'm using Excel as a primitive but very practical offline grid database. When needed, the Excel file is then uploaded and it populates a mySQL db. Now I added the support to images by encoding them base64 and save the string into a cell (mySQL will use the content of the cell to fill a BLOB...

Dear MrExcel.com, I am completely new in the malarkey of writing macros in excel so I am a bit lost in my new task. I would like to create a calculation file which implies the following: a) creates different worksheets (w/s) for each case. b) copy data from the data dump worksheet to each case...