LinkBack URL
About LinkBacks
how exactly do they look?
obvious thing would be =SUBSTITUTE(A1,".xls","")
if you want a space
=LOOKUP(10^10,--LEFT(A1,ROW($1:$99)))&" "&SUBSTITUTE(MID(A1,LEN(LOOKUP(10^10,--LEFT(A1,ROW($1:$99))))+1,255),".xls","")
how exactly do they look?
obvious thing would be =SUBSTITUTE(A1,".xls","")
if you want a space
=LOOKUP(10^10,--LEFT(A1,ROW($1:$99)))&" "&SUBSTITUTE(MID(A1,LEN(LOOKUP(10^10,--LEFT(A1,ROW($1:$99))))+1,255),".xls","")
Last edited by martindwilson; 05-08-2010 at 07:57 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hey Martin
Thanks a lot. I was not clear enough. What I want to do is the following =>
I have a dataset like this:
18abc.xls
18abd.xls
18ace.xls
19abi.xls
19bce.xls
20cde.xls
And I want to split it to something like this:
18 (next cell) abc
18 (next cell) abd
18 (next cell) ace
19 (next cell) abi
19 (next cell) bce
20 (next cell) cde
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks