Hi, I have an excel file that contains several worksheets, some of those worksheets' name begins with "Sheet" e.g (Sheet home, Sheet play, Sheet market and so on) and some of those aren't. Now I'm trying to list all worksheets name that begin with word "Sheet" by formula. so far I have found a way to count how many sheet begins with word "Sheet". I was wondering if anybody could help me on this. thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
list worksheet names that begins with a given word by formula
- Thread starter sobuj53
- Start date
-
- Tags
- list worksheet names
Similar threads
- Solved
- Question
