Hi Nadine,
The Alt+Enter leaves a character which has an ascii value of 10. So there are a
couple of things you could try. I think the CLEAN function gets rid of this
character, so if your data is in Col A, in Col B put CLEAN(A2) and copy down.
Or you could try SUBSTITUTE(A7,CHAR(10),"") which
I often receive a file that has extra Alt+Enter in it which makes the cells
long
and therefore the files long. Is there anyway I can remove these? The # rows
is 700+ - it can vary.
Thanks.
--
--
Some im
i need help on a project to convert complex spreadsheets into a more
efficient model. pls advise if anybody available ASAP. We could
discuss the payment offline. Thanks
--
--
Some important links for excel users:
1. F
Hello Friends,
Waiting for reply
Regards,
Vijay
-- Forwarded message --
From: Vijay Kr. Aggarwal
Date: Fri, Aug 6, 2010 at 10:18 AM
Subject: $$Excel-Macros$$ Question asked in Interview...
To: excel-macros@googlegroups.com
Hi,
Please check attached file. Kindly provide an
Hi Nadine,
It should still work with alphanumeric data. Any chance of a sample workbook
with the formulas in there?
Regards - Dave.
Date: Sat, 7 Aug 2010 08:26:36 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need max date
To: excel-macros@googlegroups.com
I should
Hi
I have already tried the below steps but every time i reopen excel 2007 the
option in step no. 2 automatically gets resetted
Regards
Rahul
Date: Sat, 7 Aug 2010 17:55:17 +0530
Subject: Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted
to save the changes
Hi
I am using excel 2007
Regards
Rahul
Date: Sat, 7 Aug 2010 17:52:16 +0530
Subject: Re: $$Excel-Macros$$ In Excel 2003 and in Excel 2002, you are prompted
to save the changes when no changes were made
From: aind...@gmail.com
To: excel-macros@googlegroups.com
Hi Rahul,
Which version of
I should have clarified that in the sample it is only numeric and it works but
in my actual data it's alpha numeric. It didn't occur to me it would make a
difference when I created the sample. Can I trouble you to take another look
at
it with alhpa numeric data in Col A? Sorry about that.
I'm getting the result #VALUE!. Could that be because what in column A in both
sheets is alpha numeric?
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Fri, August 6, 2010 6:53:33 PM
Subject: RE: $$Excel-Macros$$ Need max date
Hi Nadine,
Hope
**Dear All,
I need your help
I have some Mobile nos in 'a' colmn ..and that mobile no related other
information is availble in MS-Access table (data volume is 6lac)
Mobile No Name Add1 Add2 Add3 Alternate no 123456 325641
267789 325641
Please suggest me any macro
By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate
files that were last saved in an earlier version of Excel. This ensures that
any improvements made to the Excel calculation engine are applied to all
formulas in the workbook.
To prevent Excel 2003 or Excel 2002 from auto
Hi Rahul,
Which version of Excel are you using?
Regards
Andy
On Sat, Aug 7, 2010 at 5:08 PM, rahul wrote:
> When you open a workbook and then close it with out making any
> changes, you are prompted as follows:
> Do you want to save the changes to Filename.xls?
>
> Microsoft Excel recalculates
When you open a workbook and then close it with out making any
changes, you are prompted as follows:
Do you want to save the changes to Filename.xls?
Microsoft Excel recalculates formulas when opening files last saved by
an earlier version of Excel.
How to get rid of this problem
File is uploade
just go to gmail and attach ypur file there, and send it to id of this
group(excel-macros@googlegroups.com)
On Sat, Aug 7, 2010 at 9:30 AM, robert cheung wrote:
> I have a project I'd like to share on this discussion board, but every
> time I click "New Post", there is not a place for me to at
I also have the same problem. Whenever I reply to any post, I don't
get option to upload a fine in post.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.
Hi all
I have attached a file containg pivot table with some data.
I have two qurries
1. I want to put a foruma next to pivot table and want to copy and paste all
formula to all rows but its taking freezing cells by default.
If data quatity is high than how could i put the formula in all cells.
16 matches
Mail list logo