Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Home
Help
Login
Register
TheSwamp
»
Code Red
»
VB(A)
»
Topic:
String Modification (Excel)
« previous
next »
Print
Pages: [
1
] |
Go Down
Author
Topic: String Modification (Excel) (Read 4753 times)
0 Members and 1 Guest are viewing this topic.
ChrisCarlson
Guest
String Modification (Excel)
«
on:
May 30, 2018, 10:46:10 AM »
VBA is not my strong suit but I have a string that I'm trying to parse information from.
Code - vb.net:
[Select]
=
IFNA
(
VLOOKUP
(
(
IF
(
ISBLANK
(
Origin
!
$
[
b
]
C31
[
/
b
]
)
,
"-"
,Origin
!
$C31
)
)
,Data
!
$A:$A,
1
,
FALSE
)
,
"ERROR"
)
Originally I used the Mid function but quickly realized its downside when dealing with a single digit cell reference. Is there a more ideal method for extracting C31 in this case but also accounting for C1 through C100 and beyond?
Logged
ChrisCarlson
Guest
Re: String Modification (Excel)
«
Reply #1 on:
May 30, 2018, 02:21:39 PM »
Disregard, went a different approach that seems to have worked.
Logged
Print
Pages: [
1
] |
Go Up
« previous
next »
TheSwamp
»
Code Red
»
VB(A)
»
Topic:
String Modification (Excel)