I have numbers in a cell with chinese character unit of measures behind them. I need to isolate the number. Text to Columns doesn't seem to work since I cannot paste the Chinese characters in. Any help would be appreciated.
Sample Numbers :
54300个
13大卷
3.5卷
7740条
Last edited by xyshel; 01-09-2012 at 06:22 PM.
USe this formula considering ur data begins from cell A1 and then copy it down...
=REPLACE(LEFT(A1,LOOKUP(10,MID(A1,ROW(INDIRECT("1:30")),1)+0,ROW(INDIRECT("1:30")))),1,MIN(FIND(0,SU BSTITUTE(A1&0,{1,2,3,4,5,6,7,8,9},0)))-1,"")+0
#Name? error.. .
3车 #NAME?
1800条 #NAME?
7920条 #NAME?
GOT IT!!
Substitute had a space in it. THANK YOU SO MUCH!!!
Give this formula a try:
=LOOKUP(99^99,--LEFT(A1,ROW(A$1:INDEX(A:A,LEN(A1)))))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If your numbers are on starting,
=LOOKUP(9E300,--LEFT(0&A1,ROW(A$1:A$100)))
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
That also worked tigeravatar. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks