Re: Compare text string of a cell in Column A VS another cell in Colum

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Max" <demechanik@xxxxxxxxx>
Date: Wed, 1 Aug 2007 16:45:36 +0800

Apologies, the earlier paste of Ron's UDF was incomplete. Here's the
complete paste:

'===========
Function FrstLtrs(str As String) As String
' Ron Rosenfeld

Dim temp
Dim i As Long

temp = Split(Trim(str))

For i = 0 To UBound(temp)
FrstLtrs = FrstLtrs & Left(temp(i), 1)
Next i

End Function
'============

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

.

References:
- Re: Compare text string of a cell in Column A VS another cell in Colum
  - From: Max

Prev by Date: Re: Compare text string of a cell in Column A VS another cell in Colum
Next by Date: Many Sort Keys
Previous by thread: Re: Compare text string of a cell in Column A VS another cell in Colum
Next by thread: Many Sort Keys
Index(es):
- Date
- Thread

Relevant Pages

Re: Extract Capital Letters
... Recollect one way is to use this fine UDF (FrstLtrs) by Ron Rosenfeld ... Function FrstLtrs(str As String) As String ... Dim temp ...
(microsoft.public.excel.misc)
Re: Compare text string of a cell in Column A VS another cell in Colum
... here's something which might work (it uses Ron Rosenfeld's FrstLtrs ... Fuzzy Match n Conditional Formatting.xls ... Function FrstLtrs(str As String) As String ... For iCh = 1 To L1 ...
(microsoft.public.excel.newusers)
Re: How can I prompt user to select item and use as a variable
... The controls are not listed in the tab index order; ... Dim temp As String ...
(microsoft.public.excel.programming)
Re: How can I prompt user to select item and use as a variable
... Dim temp As String ... At the end of that process I want to save the spreadsheet to a specific location with a specific name. ... Dim strMonth as String ...
(microsoft.public.excel.programming)
Re: How can I prompt user to select item and use as a variable
... Dim temp As String ... Dim strMonth as String ... need to check to make sure that filename isn't already in the destiation ...
(microsoft.public.excel.programming)