Grab the specific parts of text in cell and print to other cell

Hi!

I have a list of iPad's (like 12000+ units) with some information listed in a column.

Column U2 down to U12536 is a simple =[Different sheet] grabbing the model and storage capacity.
Now what I need to do is to have in V2 and down just grab the Storage Capacity of the iPad and print it there.
and then in W2 write the type of iPad

so for example, (I'll write a few, there are more models)
U2 is iPad Air LTE (16 GB Space Gray) - Print 16 GB in V2 - Print iPad Air LTE in W2
U3 is iPad Air (32 GB Silver) - Print 32 GB in V3 - Print iPad Air in W3
U2180 is iPad Mini with Retina (16 GB Space Gray) - Print 16 GB in V2180 - Print iPad Mini with Retina in W2180
U8828 is iPad 6th Gen (128 GB Silver) - Print 128 GB in V8828 - Print iPad 6th Gen in W8828

Any good ways of doing this using a Formula to just pull down to each cell, or any ideas on a VBA Macro to run to make it happen? either way works as long as I dont have to do this manually for 12k+ units xD

Thank you in advance!

It would be better if you attached a sample Excel workbook, rather than giving us just 4 examples in your text - instructions on how to do this are given in the yellow banner at the top of the screen.

It strikes me, though, that for the model you want to grab all the text before the open bracket, so you could try this formula in W2:

=LEFT(U2;FIND(" (";U2)-1)

For the storage, you want up to 6 characters after the open bracket, so you could use this in V2:

=MID(U2;FIND(" (";U2)+2;6)

then you can copy those formulae down. You may have to use the Swedish words for those function names, depending on your regional settings.

If you have problems, then please attach a sample workbook.

Hope this helps.

Pete

Hi Pete!

Those formulas worked perfectly for what I was trying to achiev! Thank you very much!

I'll try to make a quick examplefile next time just to make it easier for every single one of you wonderful people who spend your time helping us wanna-be excel-pro's!

Thank you again!

Glad to help, but it can be difficult without seeing a range of examples of how your data may vary. Thanks for marking the thread as Solved.

You might also like to know that you can directly show your appreciation and thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete