Copying data from 2 cells into 1

's Computer Specifications

I have a different formula in 2 different cells, and I would like to combine
the responses into 1 cell. Q92 has a percentage output and R92 has a text
output. I would like E92 to be the % from Q92 and the text from R92 so that
the result in E92 is 6% Net 75, for one example. Any advice would be
appreciated. Thanks.

's Computer Specifications

Try this:

=TEXT(E92,"0%") & " " & R92

Hope this helps.

Pete

"Taylor" <(E-Mail Removed)> wrote in message
news:0A2C38CF-9D6F-434E-9ECC-(E-Mail Removed)...
>I have a different formula in 2 different cells, and I would like to
>combine
> the responses into 1 cell. Q92 has a percentage output and R92 has a text
> output. I would like E92 to be the % from Q92 and the text from R92 so
> that
> the result in E92 is 6% Net 75, for one example. Any advice would be
> appreciated. Thanks.

's Computer Specifications

Thanks, Pete. That helped.

"Pete_UK" wrote:

> Try this:
>
> =TEXT(E92,"0%") & " " & R92
>
> Hope this helps.
>
> Pete
>
> "Taylor" <(E-Mail Removed)> wrote in message
> news:0A2C38CF-9D6F-434E-9ECC-(E-Mail Removed)...
> >I have a different formula in 2 different cells, and I would like to
> >combine
> > the responses into 1 cell. Q92 has a percentage output and R92 has a text
> > output. I would like E92 to be the % from Q92 and the text from R92 so
> > that
> > the result in E92 is 6% Net 75, for one example. Any advice would be
> > appreciated. Thanks.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying data in cells	Kimmie	Microsoft Excel Worksheet Functions	3	5th Dec 2008 03:48 PM
Copying only cells with data in them	JK192503	Microsoft Excel Programming	1	27th Aug 2008 07:31 PM
copying data to different Cells	=?Utf-8?B?QXV6?=	Microsoft Excel Worksheet Functions	1	28th Apr 2006 02:28 PM
Need help with copying data from cells	paulket	Microsoft Excel Discussion	4	6th Jul 2005 11:17 AM
Copying data without blank cells, and only certain cells	Roshario	Microsoft Excel Misc	4	22nd Nov 2003 05:54 PM