Hi guys,
I have some data that I need to manipulate and include in a vlookup.
I need to make the following data
NMM Store #0001(in one cell)
NMM Store #0003
NMM Store #0004
NMM Store #0005
NMM Store #0006
NMM Store #0007
to show only
1
3
4
5
6
7
Any ideas?
| +162 | How to stop feeling like shit for not making it in IB? | 59 | 36m | |
| +119 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 3h | |
| +85 | Updated LA Banking Scene (2024) | 61 | 2s | |
| +39 | Ranking banks that went under | 24 | 12s | |
| +38 | Burnt Out M&A ASO | 20 | 16m | |
| +35 | Relevance of A-Levels for U.K. London recruiting | 24 | 4h | |
| +32 | A strategy for SA applicants late to the game like myself | 15 | 1d | |
| +27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
| +27 | Intern Ettiquette | 4 | 1d | |
| +23 | What are hours like at BBs in London? | 47 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Ok, this was fun :-)
You wouldn't have to use a vlookup fn. Let's assume your data starts in cell A1, then you could use the "Right" function in cell B1, for example:
=Right(A1,1)
I have tried that one before but it doesn't seem to work. I have about 350 of those and they are not all in sequence. For instance it could go from store 0017 store 0018 store 0023 and I want it to display is 17 18 23
the vlookup is used to pull what is associated with this data to a main summary page along with other data.
(I work in the coporate head office of a retail financal services company, if you are curious)
=VALUE(MID(A1,12,4))
use "text to column" function under tools.
What your NMM Store #0001(in one cell) NMM Store #0003 NMM Store #0004 NMM Store #0005 is not in text (say arguments whatever), you can paste value first, and then convert to columns from text.
you can use "fixed width" option or say after "#".
good luck
So... did any of the above suggestions finally work?
The text to column function worked. Thanx again for all your help.
Repellat maiores non blanditiis magni aut. Molestias iste enim non optio quia et et. Necessitatibus ipsa nemo officiis reprehenderit consequuntur velit magni. Quaerat quia voluptatem est voluptatem labore aliquam.
Tempore error ducimus et doloremque eligendi est sed numquam. Sequi nisi quae et quibusdam perferendis explicabo accusamus. Architecto officiis voluptatem qui dicta cum. Ratione consequatur at temporibus aperiam neque.
Odit eum quos enim culpa exercitationem deserunt occaecati. Libero et exercitationem assumenda est.
Et sed quis voluptas. Molestiae perspiciatis incidunt optio et. Unde qui aut in harum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...