; " & E1 & " " & F1
>
> the "displayed value" of A1 can exceed your 255 character limit.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *"Do all the good you can,By all the means you can,In
rnal" source that populates the Excel sheet?
>
> and..
>
> what is it you're trying to do?
>
> *Paul*
> -
>
>
>
>
>
>
>
> *"Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you c
m> wrote:
> Hi,
>
> use this formula.
>
> =CONCATENATE(C3,TEXT(D3," dd-mmm-"),E3)
>
> From
> Naveen
>
>
>
> On Tue, Feb 25, 2014 at 4:42 PM, santhosh qatester <
> santhosh.qat...@gmail.com> wrote:
>
>> Hi All,
>>
>>
Hi All,
In excel cell has sql query which has more than 255 characters.
which has string+date+string when i use concatenate or & symbol it throws
error message
can you please let me know there is any alternate for concatenate function
in excel
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Hi,
I have the value as below in one cell which should assign the
Today's date to particular value
WHERE( ImportDate= Today())
How to assign today's date to the variable above?
Thanks,
Santhosh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RU
Hi Noorain,
Please send to my mail id
Regards,
Santhosh
On 5/30/12, vijayKumar wrote:
> Hi Noorain,
>
> Please send me the files at
> midearfam...@gmail.com
>
> Regards
> Vijay
>
> On Wed, May 30, 2012 at 11:27 AM, ashwani agnihotri <
> ashwani.agniho...@gmail.com> wrote:
>
>> Hi Noorain,
>>
>
Congrats Ayush :)
Regards,
Santhosh
On Tue, Oct 4, 2011 at 12:14 AM, Ayush Jain wrote:
> Dear members,
>
> I am proud to share that I have been re-awarded the Micrososft MVP award in
> 2011. My deep thanks to each group member for all your support and
> contribution to this group.
> I keep s
Hi,
1.Select the contents which are merged and copy in to notepad
2.Now Open the excel sheet
3. Click on from text in the Data Tab
4.Select the file and click on import
5.Select delimitedand click on Next and tehn select space and tab
6.click on finish
7.Select the cell
8.Contents are displayed in
