software

Hi Group,

I have a question on using VBA for merging information in cells and
changing the format. We do have a printout from a tabulation program
(WinCross) which looks the following:

Blue Green Yellow

(A) (B) (C)

46.5% 35.4% 43.0%

Bc AC aB
That means, Blue (46.5%) is significantly different at the 95% level
from Green and at the 90% level from Yellow

This is spit out for about 100 tables. We now want to merge some of
that info and also have the format changed, i.e.

Blue Green Yellow
47%(B) 35%(A,C) 43%(B)

In words: we need the percentage without the decimals and then the
capital letters in parentheses, separated with a comma. To make things
worse, it should also have the (A,C) et al. in superscript.

Is there a way how I can do that in VBA? I have a rough idea how to
get the two cells together, but I stumble over three things:

1) When I merge the cells, I get endless decimals, i.e.
..4653988798798(B) for the first column.

2) I would need nothing if there is nothing in terms of significance,
but an open bracket, closed bracket if there is at least one
significance indicator and commas if there is more than one letter. So
if it is the last significance level, there would be a closed bracket,
if there is at least one more coming, there would be a comma and a
space)

3) How do I get the superscript formatting for everything from the
fourth character on?

Thanks a bunch, I will give Santa Claus a letter of recommendation for
all those who make suggestions.

KatscheI can help with part of it

gt; 1) When I merge the cells, I get endless decimals, i.e.
gt; .4653988798798(B) for the first column.

Assuming 0.465 ... is in A2 and (B) is in B2
Try
=TEXT(A2,quot;0%quot;)amp;B2

gt; wrote in message ups.com...
gt; Hi Group,
gt;
gt; I have a question on using VBA for merging information in cells and
gt; changing the format. We do have a printout from a tabulation program
gt; (WinCross) which looks the following:
gt;
gt; Blue Green Yellow
gt;
gt; (A) (B) (C)
gt;
gt; 46.5% 35.4% 43.0%
gt;
gt; Bc AC aB
gt;
gt;
gt;
gt; That means, Blue (46.5%) is significantly different at the 95% level
gt; from Green and at the 90% level from Yellow
gt;
gt; This is spit out for about 100 tables. We now want to merge some of
gt; that info and also have the format changed, i.e.
gt;
gt; Blue Green Yellow
gt; 47%(B) 35%(A,C) 43%(B)
gt;
gt; In words: we need the percentage without the decimals and then the
gt; capital letters in parentheses, separated with a comma. To make things
gt; worse, it should also have the (A,C) et al. in superscript.
gt;
gt; Is there a way how I can do that in VBA? I have a rough idea how to
gt; get the two cells together, but I stumble over three things:
gt;
gt; 1) When I merge the cells, I get endless decimals, i.e.
gt; .4653988798798(B) for the first column.
gt;
gt; 2) I would need nothing if there is nothing in terms of significance,
gt; but an open bracket, closed bracket if there is at least one
gt; significance indicator and commas if there is more than one letter. So
gt; if it is the last significance level, there would be a closed bracket,
gt; if there is at least one more coming, there would be a comma and a
gt; space)
gt;
gt; 3) How do I get the superscript formatting for everything from the
gt; fourth character on?
gt;
gt; Thanks a bunch, I will give Santa Claus a letter of recommendation for
gt; all those who make suggestions.
gt;
gt; Katsche
gt;