LinkBack URL
About LinkBacks
Hi guys!
I have a question about extract numbers/words from a string in excel not use VBA.
In A1: 1234ABCD
In A2: 123DEF
In A3: 1234FGH
In A4: 123HKLM
and
In B1: I want get 123 from A1
In C1: I want get ABCD from A1
so on...
Thanks!
Hi guys!
I have a question about extract numbers/words from a string in excel not use VBA.
In A1: 1234ABCD
In A2: 123DEF
In A3: 1234FGH
In A4: 123HKLM
and
In B1: I want get 123 from A1
In C1: I want get ABCD from A1
so on...
Thanks!
B1:
=lookup(10^10,left(a1,column($1:$20))+0)
c1
=substitute(a1,b1,"")
jindon, I would suggest that you use bigger number in lookup function.
10^10 is just 10 billions and in some cases can be reached so your formula will return wrong value.
OK, in this case numbers are smaller.. But why bother thinking about that
for example, writting 99^99 is also faster.
140^140 will bring you very close to biggest number wich is 9.99999999999999E+307.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks