Hi again all.
I need your help again please. I want to put 2 numbers in one cell say: "14 space 3" into two separate variables. Is this possible? If so, how do I do it.
Many thanks in advance.
Jim
Hi again all.
I need your help again please. I want to put 2 numbers in one cell say: "14 space 3" into two separate variables. Is this possible? If so, how do I do it.
Many thanks in advance.
Jim
not sure if i understand you correctly, but try this, assuming your data is in A1 and B1...
=A1&" "&B1
let me know if this was what you want. if not, try to explain better and/or upload a sample worksheet (NOT a pic)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi
Thanks for your reply. What I've got is, two numbers in one cell IE: in cell A4 I might have the number 14 then a space and then the number 3 both in cell A4. What I want to know is, is it possible for VBA to look in the cell and put the number 14 into one variable and then put the number 3 into another variable?
You can do this as long as there will always be Number space Number
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
if there is consitance in your data, yo could do this with a formula too, using =left() and right()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks