cleansing
You can use =trim() formula to remove the blanks in end of the word or starting
of the word.
On 30-Oct-2013 4:37 AM, "Pehrson, Dave"
mailto:dpehr...@walbro.com>> wrote:
I have a situation where I down load data and delineate results leaving a name
with blanks behind the
I have a situation where I down load data and delineate results leaving a name
with blanks behind the number making a Vlookup difficult.
ASIAN HONDA MOTOR CO.,LTD.
The name above is an example. Is there a formula I can use to remove any
blanks behind the last character?
Your help as always is
Don, I apologize for a delayed response, your response was shuffled my
"junk" mail, and I had overlooked it. I appreciate you looking at my request.
I'm not a programmer, so you are right on, I often do things the hard way, not
knowing the easy way. Let me re-think the request and better
I'm trying to create a macro process to automate a process that uses a "Cell
Find" formula. I need to use a looping process to make the solution capable of
handling various area with a different number of production lines.
Attached is a simple spreadsheet with an example of the process.
Cell
I have developed a matrix to capture change over time from one production model
to another, and now I need to upload into a software package with a format as
from
To
Time
WT-628
WT-628
0
WT-628
WT-629
15
WT-628
WT-630
45
(see attached partial example of requested output.
The process
The attached is a worksheet that I'm working with, actually the data
runs to over 100,000 lines, but I have shortened the example. Macro1
contains a formula that I wish to place into cells D4 to E9, then copy
and paste to the end of the data.
Note, each block is a set of 5 line for one part
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutoria
legroups.com
Subject: Re: $$Excel-Macros$$ Sum If
FOR EXAMPLE CE5 is having date
=SUMIF($F$5:$BM$5,"="&CE5,$F7:$BM7)
On Sun, Mar 27, 2011 at 6:29 AM, Pehrson, Dave
wrote:
In the sumif function shown below, I'm referencing a date:
,"=04/25/2011"
=SUMIF($F$5:$BM$5,
m: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Tuesday, March 22, 2011 1:29 AM
To: Pehrson, Dave
Cc: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in
excel
Oopss...!!
Quick Solution:- Create a sheet by the name of "backup" in your work
Thanks, I never lost faith, will review in the morning.
Thanks a million for all your support.
Best Regards
Dave
-Original Message-
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Tuesday, March 15, 2011 10:27 PM
To: Pehrson, Dave
Cc: excel-macros@googlegroups.com
Subject: Re
...@gmail.com]
Sent: Wednesday, March 02, 2011 10:17 PM
To: excel-macros@googlegroups.com
Cc: Pehrson, Dave
Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in
excel
Hi Dave,
This is a kind of realistic problem which many user faces on daily
basis. I have designed the solution for you
You're the best, thanks again
Dave
-Original Message-
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: Wednesday, March 02, 2011 10:22 PM
To: excel-macros@googlegroups.com
Cc: Pehrson, Dave
Subject: Re: FW: $$Excel-Macros$$ Macro to Average a series of numbers
in excel
Dear
: Pehrson, Dave
Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in
excel
Hi Dave,
This is a kind of realistic problem which many user faces on daily
basis. I have designed the solution for you which you can further
customize as per your changing requirements. See the attached file
Ashish,
This works great, I'm just beginning to learn the basics of VB, To a
newbie like me, the code seems strange, if you have a minute could you
explain what your simple commands are doing. Maybe I can learn to
expand for other options.
Again, thanks for your help and support.
Dav
Thank you Rana, for your kind support. Is it possible to accomplish this with a
macro as I hane many rows to deal with?
Thanks
Dave
From: excel-macros@googlegroups.com
To: excel-macros@googlegroups.com
Sent: Sat Feb 26 01:45:23 2011
Subject: Re: $$Excel-Macro
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Special Suffix Identification
try this
On Sat, Feb 19, 2011 at 12:42 AM, Pehrson, Dave
wrote:
Thanks for your quick response, you're getting close, the following is
an example of what I'm trying to achieve. Column A is the original
data, and Column
Thanks for your quick response, you're getting close, the following is
an example of what I'm trying to achieve. Column A is the original
data, and Column A together with Column B is the desired result.
188-512
76-544
84-737-JP
JP
AT-2-CH
CH
CAA-166
FPC-7
Paul, thanks for your interest and quick response.
Please reference response in Red
The following is an example of the variability of characters. Note the
one parts in red are the parts I want to identify
188-512
76-544
84-737-JP
JP
AT-2-CH
CH
CAA-166
F
18 matches
Mail list logo
