HELP: Need to separate values from a single cell with multiple values
Hi,
I am at a lost on how to do this and sorry if I do not get it straight away, anyhow here goes:
Cell Value (This is how it is spaced out within the cell) = DTL 5123456 Change 2000012010030920130206 51234567 Platinum
I am wanting to find a formula that will:
1. Separate each data into a single cell (e.g A1=DTL 5123456, A2=Change, A3=2000...etc)
2. Retrieve the date(s) within the large 2000...#
Any help will be greatly appreciated, apologies if I have not explained well.
Cheers
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Re: HELP: Need to separate values from a single cell with multiple values
Sample Book.xlsxThanks 6thsense...Hopefully I have done this right - Sample attached
look at attachment was not able to finish have to go..
longwords.xlsx
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thanks Vlady, really appreciate it! :-) Hopefully someone will be able to help with the last column and maybe be able to explain this method used so I need not to ask again in the future - Thanks :-)Originally Posted by vlady
MID(TRIM(A2),FIND("@",SUBSTITUTE(TRIM(A2)," ","@",5)),15)
you can use above formula to extract the last column.
Hello MrBrownGuy, I know Valdy has provided the correct solution and although this thread is solved but you can have a look at this alternative also.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks