text in cells

I read a post in this forum that shows how to make multiple text lines, in 1 cell, into bullet points which works great. Here is the code:- Sub aTest() Dim rCell As Range, spl As Variant, i As Long For Each rCell In Selection spl = Split(rCell, Chr(10)) For i =...

When I enter text in a cell, everything looks fine until I exit the cell, when random line breaks/gaps suddenly appear in the text. When I go back into the cell, everything reverts to normal until I exit again. Restarting the computer doesn't help. The only way I can get get rid of the line...

Hello, dear VBA masters Does anybody know how to transform text in cell into table using VBA I have a list of our customers with their contact information. The emails and phone numbers are being stored in the cells. I need to extract them and create the table and use them / update and etc in...

Please can anyone help! I am trying to enter a countif function in order to calculate the number of yes & no's to male & females! In one column I have 'Y & N' & in a 2nd column 'M & F'. I need to be able to calulate the number of Male Yes & No' & the number of female Yes & No. Hope this...

Hello, I have a macro that I use to test quantities of items. I would like to add a capability to this macro so that I can see if the cell it is searching contains text and if it does, to skip that cell and go to the next item. If it doesn't have text I would like it to check the quantity...