Hi,
I have 30 workbooks, each with 20 sheets with data that needs cleaning
I have tried left and right but the lengths differ?
any help greatly appreciated
Thanks
Kevin
Hi,
I have 30 workbooks, each with 20 sheets with data that needs cleaning
I have tried left and right but the lengths differ?
any help greatly appreciated
Thanks
Kevin
You could use variants of this:
=LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))-1)+0
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you Glenn
If you are looking for formulas based on sample:
H1: =LEFT(A1,(FIND(" ",A1,1)-1))
I1: =LEFT(TRIM(B1),(FIND(" ",TRIM(B1),1)))
may be
k1=LOOKUP(99^9,MID(A1,1,ROW(INDIRECT("1:14")))+0)
Try this and copy across
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Paul, Both worked...thanks
Siva, wow...that's a really cleaver formula.
Now I need to figure out how that works! What is the indirect doing here??
Thanks
Kevin
Here's another "off beat" solution along a similar line!!
=LOOKUP(10^10,--LEFT(A1,ROW($1:$14)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks