text3

The following code works fine, only I would like to insert a line of code to change the text to Upper case and another line to change the size of the font. Any help would be much appreciated: Dim i As Integer Text(1) = "text1" Text(2) = "text2" Text(3) = "text3" For i = LBound(Text)...

Col A Col B Text1 Text1 Text2 Text1 Text3 Text1 Text4 Text1 Text5 Text2 Text6 Text2 Text2 Text2 Text3 Text3 Text3 Text3 Need a formula in column B to copy data from Col A & increment...

In excel 2016, I am trying to concatenate text with a number but decimal point but will not show, i.e. "test"&C2 where C2 contains 3.0. I just get Text3 instead of Text3.0. what am i doing wrong? Cheers Clive

Hi, I cannot find a solution for my problem. Is it like this: <tbody> A B C D E F G H AB H1 0 TEXT1 CRITERIA1 A= AB AB J5 40 TEXT2 CRITERIA2 B= J5 AC R5 5 TEXT3 CRITERIA3 C= 40 FG H9 3 TEXT4 AB J5 40 TEXT5 MATCHES= TEXT2 AB J5 20 TEXT6 TEXT5 HZ D5 6 TEXT7...