Awesome, thanks
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Wed, 29 Feb 2012 08:38:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Concatenate help
*Try it:*
=TEXT(A1,".?")&a
macros@googlegroups.com
> *Date: *Wed, 29 Feb 2012 01:04:59 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Concatenate help
>
> Hi Joseph,
>
>
> use concatenate with text formula
>
> =CONCATENATE(A2," "
Thank your for a prompt reply.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: xlstime
Sender: excel-macros@googlegroups.com
Date: Wed, 29 Feb 2012 01:04:59
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Concatenate help
Hi Joseph,
use
Hi Joseph,
use concatenate with text formula
=CONCATENATE(A2," ",TEXT(A3,"0.00%"))
On Wed, Feb 29, 2012 at 1:01 AM, wrote:
> Hi guys,
>
> I am trying to concatenate two cells.
>
> One cell ha absolute number whereas the other cell is a percentage.
>
> For e.g.,
> Cell A1 = 10.534809
> Cell
Hi guys,
I am trying to concatenate two cells.
One cell ha absolute number whereas the other cell is a percentage.
For e.g.,
Cell A1 = 10.534809
Cell A2 = 18.5648%
The output should be:
Cell A3 = 10.5 18.5%
But my output with Concatenate formula is 10.534809 0.185648
Please help.
Best,
Jos
