![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
(no subject)
Oct. 23rd, 2007 11:30 amExcel question from me, who is probably an intermediate user, but knows sod-all about VB:
I have a text cell containing a number, a dash, and some text - eg "170001001 - Cash - Within Own Business". I want to isolate the number, so I can do a lookup against it from another table of similar numbers. Come to think, I may want to isolate the number and stick an "M" on the front of it.
Actually, the problem is more that I have 3,000 of the little sods.
Not the end of the world if I can't do it, but might make life easier.
Any thoughts? And assume I'm moderately stupid for the purposes of this exercise.
I have a text cell containing a number, a dash, and some text - eg "170001001 - Cash - Within Own Business". I want to isolate the number, so I can do a lookup against it from another table of similar numbers. Come to think, I may want to isolate the number and stick an "M" on the front of it.
Actually, the problem is more that I have 3,000 of the little sods.
Not the end of the world if I can't do it, but might make life easier.
Any thoughts? And assume I'm moderately stupid for the purposes of this exercise.
