Anti-Concatenate. I have run through how using concatenate for constructing things is great, but it is also useful to know how to deconstruct them from a reporting point of view. I have two main ways ...

You can also use the concatenate function to combine more than two columns. Step 1: I typed in =CONCATENATE(A2,B2,C2) into its own cell. Change the column letters to ones of your choosing, and ...

Divide the text/numbers in a set of cells that are either pure text or pure numbers and format them accordingly. Play with several widths.<BR><BR> my 2 cents,<BR><BR> Caos ...