split cell - again! 3

[CCNProjects]

Hello all.

I read the thread about never splitting a cell, but I need to do this.

This is what I have:
col1 col2 col3 col4
AA 5% 3% xxxx
BB 7% 2% yyyy

I need to display data as:

col1 col2
AA xxxx
D5%, C3%
BB yyyy
D7%, C2%

I tried (="D " &B2 & ", C" & C2), but I get this result:
D 0.0450777906517539, C 0.0252490915272274

How can I format the percentages?
Thanks for any hint.

 

[GlennUK]

Is this was you want:

="D " & TEXT(B2,"0%") & ", C" & TEXT(C2,"0%")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

what" not "was"

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

What about using a pivot table?

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[AnotherHiggins]

First of all, what thread are you talking about? A link might help provide some context as to what you are talking about. Remember: we can't read minds.

But to answer your question, you would use the TEXT function.

[tab][COLOR=blue white]="D" & [red]Text([/red]B2[red],"0%")[/red] & ", C" & [red]Text([/red]C2[red], "0%")[/red][/color]
(I also got rid of the extra space after "D")

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[CCNProjects]

Thank you very much for your help.

I hate to say this, but I don't have any result, only the formula itself. I formatted (Format Cell...) my column, but to no avail.

 

[AnotherHiggins]

You mean you see the formula itself in the cell, right?

After formatting the column as General, double click to edit one of the cells containing a formula and press enter.

If that doesn't work, press [Ctrl]+[`] (to the left of the [1] key at the top left of the keyboard).

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.