A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 52
Search took 0.14 seconds.
Search: Posts made by: Luciano Paulino da Silva
Forum: Worksheet Functions November 6th, 2009, 03:43 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 131
Palindromes

On 22 out, 16:52, "Bernie Deitrick" deitbe @ consumer dot org wrote:
Luciano,

Why not GQG and AGGA also? Can each individual character only be used once?

HTH,
Bernie
MS Excel MVP

...
Forum: Worksheet Functions October 22nd, 2009, 11:03 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 131
Palindromes

Dear all,
Some time ago...
Forum: Worksheet Functions April 27th, 2009, 02:22 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings(0/1)

On 24 abr, 08:29, Ron Rosenfeld wrote:
On Sun, 19 Apr 2009 08:02:47 -0700 (PDT), Luciano Paulino da Silva

wrote:
Dear Ron,
You...
Forum: Worksheet Functions April 19th, 2009, 04:54 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 19 abr, 09:23, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 19:32:26 -0700 (PDT), Luciano Paulino da Silva



wrote:
Dear Ron,
I...
Forum: Worksheet Functions April 19th, 2009, 04:24 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 19 abr, 09:23, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 19:32:26 -0700 (PDT), Luciano Paulino da Silva



wrote:
Dear Ron,
I...
Forum: Worksheet Functions April 19th, 2009, 04:18 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 19 abr, 09:23, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 19:32:26 -0700 (PDT), Luciano Paulino da Silva



wrote:
Dear Ron,
I...
Forum: Worksheet Functions April 19th, 2009, 04:02 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 19 abr, 09:23, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 19:32:26 -0700 (PDT), Luciano Paulino da Silva



wrote:
Dear Ron,
I...
Forum: Worksheet Functions April 19th, 2009, 01:47 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 19 abr, 09:14, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 20:04:16 -0700 (PDT), Luciano Paulino da Silva

wrote:
I`m having some...
Forum: Worksheet Functions April 19th, 2009, 04:04 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 18 abr, 22:36, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 18:12:42 -0700 (PDT), Luciano Paulino da Silva



wrote:
On 18 abr,...
Forum: Worksheet Functions April 19th, 2009, 04:03 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 18 abr, 23:32, Luciano Paulino da Silva
wrote:
On 18 abr, 22:12, Luciano Paulino da Silva



wrote:
On 18 abr, 15:18, Ron...
Forum: Worksheet Functions April 19th, 2009, 03:32 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 18 abr, 22:12, Luciano Paulino da Silva
wrote:
On 18 abr, 15:18, Ron Rosenfeld wrote:

On Sat, 18 Apr 2009 07:50:32 -0700 (PDT),...
Forum: Worksheet Functions April 19th, 2009, 02:12 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 18 abr, 15:18, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 07:50:32 -0700 (PDT), Luciano Paulino da Silva

wrote:
Dear Ron,
...
Forum: Worksheet Functions April 19th, 2009, 02:06 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 18 abr, 15:18, Ron Rosenfeld wrote:
On Sat, 18 Apr 2009 07:50:32 -0700 (PDT), Luciano Paulino da Silva

wrote:
Dear Ron,
...
Forum: Worksheet Functions April 18th, 2009, 03:50 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

On 17 abr, 22:32, Ron Rosenfeld wrote:
On Wed, 15 Apr 2009 10:49:37 -0700 (PDT), Luciano Paulino da Silva



wrote:
Dear All,
...
Forum: Worksheet Functions April 18th, 2009, 02:01 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

I`m very happy that you said that a lot of the rules are simple to
implemnt. I have successfuly tested that one you send me.
Thank for your help with this.
Luciano

On 16 abr, 21:08, Luciano Paulino...
Forum: Worksheet Functions April 18th, 2009, 02:00 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 333
Split text file into Excel sheet and separate the final resultsinto a new sheet

Dear Glenn,
I think that it will be necessary that I find another strategy since
my text files are as large as that one I sent you.
Despite I use Excel 2007, I think that it will not be possible...
Forum: Worksheet Functions April 17th, 2009, 01:08 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 25
Views: 195
Macro to apply parsing rules for strings and list the substrings

Bernie,

OK, We will have just 20 types of letters:

A, C, D, E, F, G, H, I, K, L, M, N, P, Q, R, S, T, V, X

For some situations, I will have some new future rules and it is
possible that in several...
Forum: Worksheet Functions April 16th, 2009, 08:01 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 333
Split text file into Excel sheet and separate the final resultsinto a new sheet

It is one of my files:
http://www.savefile.com/files/2079390
Thanks in advance,
Luciano

On 16 abr, 15:05, Glenn wrote:
There were no limits to the solution I provided, unless...
Forum: Worksheet Functions April 16th, 2009, 04:59 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 33
Views: 303
Macro for detect palindromes and repeats in letters/numbersstring

Dear Bernie,
I would like to thanks you for all this help. I'm currently running
absolutely all my strings with no problem and this is due to your
efforts.
Thanks you!
I'm currently with my new...
Forum: Worksheet Functions April 16th, 2009, 04:55 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 33
Views: 303
Macro for detect palindromes and repeats in letters/numbersstring

Do not worry!
I saw that before you can send me the msg.
Thank you very much!
Luciano

On 16 abr, 07:52, "Bernie Deitrick" deitbe @ consumer dot org wrote:
I accidentally left in a debugging...
Forum: Worksheet Functions April 16th, 2009, 04:52 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 333
Split text file into Excel sheet and separate the final resultsinto a new sheet

Dear Glenn,
Thank you very much for your file.
The spaces are inserted. However, my data have hundreds of headers and
consequently data, but I can not understand how could I put them to
the...
Forum: Worksheet Functions April 16th, 2009, 11:41 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 33
Views: 303
Macro for detect palindromes and repeats in letters/numbersstring

Dear Bernie,
Thank you very much!
It is working. However, I have to sum the values bellow B3 in order to
get the total numbers of repeats observed that is different from the
total number of different...
Forum: Worksheet Functions April 16th, 2009, 02:26 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 33
Views: 303
Macro for detect palindromes and repeats in letters/numbersstring

Dear Bernie,
Thank you very much for your attention.
Yes, I have performed all these operations, but I had created a new
sheet into the same file that it was the palindromes code.
Now, I created a...
Forum: Worksheet Functions April 16th, 2009, 12:24 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 33
Views: 303
Macro for detect palindromes and repeats in letters/numbersstring

Dear Bernie,
I tried a lot to run the code but it is not working. Have you some
idea about what could it be happening?
I just receive the error: #NAME! for all cells in the interval.
Thanks in...
Forum: Worksheet Functions April 15th, 2009, 11:27 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 33
Views: 303
Macro for detect palindromes and repeats in letters/numbersstring

Yes, it is exactly what I want. Is it possible to you modify the code
for me?
Thanks in advance,
Luciano

On 15 abr, 09:49, "Bernie Deitrick" deitbe @ consumer dot org wrote:
OK for for...
Showing results 1 to 25 of 52

 
Forum Jump

All times are GMT +1. The time now is 02:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.