Folks, I need help - I have the following that I would like to separate the number from the letter, but it's dropping a letter for one row (highlighted, with problem in cell C3 - could someone please help!
Folks, I need help - I have the following that I would like to separate the number from the letter, but it's dropping a letter for one row (highlighted, with problem in cell C3 - could someone please help!
FIND returns the position where it occurs. You just got lucky that the first two examples have 7 character numbers (including the space) and 7 character strings. As soon as your number was shortened, and the space character is now found at position 5, so RIGHT is returning the 5 right hand characters. If you add or remove characters in the top two examples, you'd see the problem is there, too, just hidden.
You need to subtract the LEN of the string from the result of the find to yield the proper value for RIGHT.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Yes! Thanks Pauleyb - if anyone needs, here's the formula for that cell =RIGHT(A3,LEN(A3)-FIND(" ",A3))
Try this
Enter formula in B1 and drag formula across to C1 and down
Formula:Please Login or Register to view this content.
v A B C 1 30.848 EHash/s 30.848 EHash/s 2 222.93 THash/s 222.93 THash/s 3 4.817 EHash/s 4.817 EHash/s
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for showing us that. There are obviously many ways of getting the same answers in excel, here are some more options...
B1=--LEFT(A1,FIND(" ",A1))
C1=MID(A1,FIND(" ",A1)+1,99)
This assumes that that space will always be there to split the text and number
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
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks