We help IT Professionals succeed at work.

How to extract the first word from the cell in a column nd paste it in another column using vba.

aditee
aditee asked
on
122 Views
Last Modified: 2017-11-18
Hi,
I know how to extract the first from a cell in a column and paste in another column using vba. But what i want is if the first text is a number then 2nd text should get extracted. Please help me out with the problem.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Bill PrewTest your restores, not your backups...
CERTIFIED EXPERT
Expert of the Year 2019
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2016

Commented:
Since we don't know the separator, the regex solution works for more possibilities