Hello all,
I am looking to return the characters before the "u". Right and Left syntax does not help me seeing the characters before the "u" differ.
2u10000~a x 2
a81u3000~- x 44
1a81u300~- x 8
cg8zu30000~-
17uar~c
45u10~a
517uar0
Thank you in advance.
John
Assuming those values are in A1 going downward, put this in B1 and copy down:
=LEFT(A1, SEARCH("u", A1)-1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That works,
Thank you very much!
Question... What if I wanted to return the characters to the Right of the "U".
Replacing Left with Rights seem to still show the "u" plus extra characters.
That would be:
=RIGHT(A1, LEN(A1)-SEARCH("u",A1))
What does the LEN do?
Measures Length of a string. You can press F1 in Excel and read the builtin help file on any given function you come across.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks