Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Info in Two Cells
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. Katsche |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Info in Two Cells
I can help with part of it
1) When I merge the cells, I get endless decimals, i.e. .4653988798798(B) for the first column. Assuming 0.465 ... is in A2 and (B) is in B2 Try =TEXT(A2,"0%")&B2 wrote in message ups.com... 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. Katsche |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Protection of worksheet / merging Cells | Excel Worksheet Functions | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Merging cells with text as one line | Excel Worksheet Functions |