Hello MartyH,
I was able to do this by installing NcFTP on my computer. It is
available here: http://www.ncftp.com/download/. You want to install
the client (not server.)
Once you install that program, modify the following code to accomplish
saving to an FTP file:
Sub SaveTXT2FTP()
'
' SaveTX
Name: Justo Morales
Subject: Data Summary
Detail: Sometimes you need to get a summary of many different values.
However, you may not be sure what fields you have listed. For
example, say you have the total number of colors produced by day for
an entire month. You want to know exactly how many of
Dave, I think Praveen was looking for the count from right to left.
Your example formula results with 17 not 8. However, building on your
formula, you can simply subtract from the length of the cell. Here is
counting from right to left:
=LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(
