• Status: Solved
• Priority: Medium
• Security: Public
• Views: 560

# Formula and text together in Excel

I'm sorry but this is probably a really silly one. How can I put the results of a query into a string? So if I want a merged cell to read "(x)% of all student receive aid" where (x) is the result of cells A3/K68 how would i do that?
0
bpfsr
• 4
• 2
• 2
1 Solution

Commented:
Hi bpfsr,

Try this:

="(" & A3/K68  & ")% of all student receive aid"

or this:

="(" &TEXT( A3/K68*100,"#.##")  & ")% of all student receive aid"

Jim
0

Commented:
bpfsr:

You would use the TEXT function to format your calculation and then concatenate it to the text by using the ampersand.

=TEXT(A3/K68,"(0)%")&" of all student receive aid"

Kindest Regards,

Jaes
0

Commented:
Jim:

Hey there man!  Nice to see you around again!  'Course I'm just back myself, so perhaps you've been here all along...  ;)

Jaes
0

CACommented:
Do You really need the brackets ? Try this, just a little change.

=TEXT( A3/B68*100,"0.00")&"% of all student receive aid"

Kanwaljit
0

Commented:
Jim and Kanwaljit:

Why are you guys multiplying by 100?  If it is a true % the TEXT function will take care of the % since it formats the result.

=TEXT(A3/B68,"0%")&" of all student rerceive aid"

<grin>

Jaes
0

Commented:
Jim and Kanwaljit:

Of course...  I assume they didn't 'rerceive' the aid.  :)

=TEXT(A3/B68,"0%")&" of all student receive aid"

Jaes
0

CACommented:
Hi Jaes.
You are right. I was trying to dispense with the brackets only, but seems to have overlooked % in the text function.
Kanwaljit

(But you certainly will have to pay me \$10 to continue my membership ;)
0

Commented:
bpfsr,

And, in case you needed to do this in code, you would use the Format() function like this:

[B2].Value = Format([A3] / [K68], "0.##%") & " of all students recieve aid."

- Hey Jaes!

I'm just in and out these days.  Nice to see you back!

Jim
0

## Featured Post

• 4
• 2
• 2
Tackle projects and never again get stuck behind a technical roadblock.