in vba
is left and right the only way to extract substring?
e.g.
● AAA (BBB 14:45:8)
i only need AAA and the numbers in 2 columns
in vba
is left and right the only way to extract substring?
e.g.
● AAA (BBB 14:45:8)
i only need AAA and the numbers in 2 columns
Re: Substring
Also the MID command.
ADDED BY ADMIN
Left
Right
Mid
Split
Instr
Instrev
Replace
Re: Substring
Split
Re: Maco Functions For Parsing Sub-Strings
Quote from raphain vba
is left and right the only way to extract substring?e.g.
● AAA (BBB 14:45:8)
i only need AAA and the numbers in 2 columns
try
UDF
Select B1:C1
Enter =rapha(A1)
Then confirm with Ctrl + Shift + Enter (array formula entry)
Re: Maco Functions For Parsing Sub-Strings
Hi Jindon,
Am I doing something wrong I followed your instructions and tried the example; but no joy.
I am and have been playing around with the VBscript but can get it to work??
In this case all i get is the value of a1 in both b1 and c1.
joyless pike
Re: Maco Functions For Parsing Sub-Strings
Hi pike
Replace the pattern in Jindon's code by:
And then use Jindon's instructions:
- Select B1:C1
- Enter =rapha(A1) in the formula bar
- Then confirm with Ctrl + Shift + Enter (array formula entry)
HTH
lecxe
Re: Maco Functions For Parsing Sub-Strings
Hey Thanks lecxe
I'll now have to try and nut it out
Much joy pike
Don’t have an account yet? Register yourself now and be a part of our community!