We help IT Professionals succeed at work.
Get Started
Help with editing cell with data in excel sheet
Hi,
I have excel sheet that has a column with words + number, for Example: "Test 1234" or "Test1234" or "Test Test 1234",
I need VBA code which will split the string into columns,
The VBA Code will search the whole column and move the number to the cell next to it.
For example if cell A1 is: "Test 1234" and cell A2 is: "Test 4321" and cells B1 and B2 are empty,
Than this VBA Code will move from A1 "1234" to the B1 cell and from B1 it will move the "4321" to B2,
This code needs to ignore numbers that are smaller than 5 digits and cells with no number at all.
I have excel sheet that has a column with words + number, for Example: "Test 1234" or "Test1234" or "Test Test 1234",
I need VBA code which will split the string into columns,
The VBA Code will search the whole column and move the number to the cell next to it.
For example if cell A1 is: "Test 1234" and cell A2 is: "Test 4321" and cells B1 and B2 are empty,
Than this VBA Code will move from A1 "1234" to the B1 cell and from B1 it will move the "4321" to B2,
This code needs to ignore numbers that are smaller than 5 digits and cells with no number at all.
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE