Results 1 to 6 of 6
Thread: EXCEL
Hybrid View
-
6th May 2017 19:33 #1Registered User
Join Date: Jun:2010
Location: .
Posts: 55
EXCEL
, EXCEL .
- . , , .
excel .
Find , .
- , . , , .
&, , & TRIM .
. excel .
-
6th May 2017 22:25 #2-==-
Join Date: Sep:2003
Location:
Posts: 6,444
-
6th May 2017 23:05 #3Registered User
Join Date: Aug:2002
Posts: 1,145
-
6th May 2017 23:52 #4Registered User
Join Date: Jun:2010
Location: .
Posts: 55
.
Index Match .
Vlookup , .
-
6th May 2017 23:54 #5Mire-x
Join Date: Apr:2005
Location: Sofia
Posts: 763
- VBA. , :
http://stackoverflow.com/questions/8...-cell-in-excel
:
, :Code:=ConcatenateRange(A1:A1000)
VBA Excel, ( WS TeleshopCode:Function ConcatenateRange(ByVal cell_range As range, _ Optional ByVal seperator As String) As String Dim cell As range Dim newString As String Dim cellArray As Variant Dim i As Long, j As Long cellArray = cell_range.Value For i = 1 To UBound(cellArray, 1) For j = 1 To UBound(cellArray, 2) If Len(cellArray(i, j)) <> 0 Then newString = newString & (seperator & cellArray(i, j)) End If Next Next If Len(newString) <> 0 Then newString = Right$(newString, (Len(newString) - Len(seperator))) End If ConcatenateRange = newString End Function
):
http://www.dummies.com/software/micr...cel-functions/(10b) || !(10b)
-
7th May 2017 16:41 #6Registered User
Join Date: Jun:2010
Location: .
Posts: 55
, Vlookup .
.
, . .




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in