Hi all. I need assistace please. I have text data that I copied into an excel worksheet. I need to combine the data and then split the data and figure into two columns.your assistance is much appreciated.
Hi all. I need assistace please. I have text data that I copied into an excel worksheet. I need to combine the data and then split the data and figure into two columns.your assistance is much appreciated.
Are you still on Excel 2007 ? If not, please update your profile to show your current version as answers do depend on knowing this.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Try
in C5
=INDEX(MID($A$5:$A$100,FIND("(",$A$5:$A$100),255),AGGREGATE(15,6,ROW($A$1:$A$1000)/($A$5:$A$100<>"")/(ISTEXT($A$5:$A$100)),ROWS($1:1)))
enter with Ctrl+Shift+Enter
in D5
=INDEX($A$5:$A$100,AGGREGATE(15,6,ROW($A$1:$A$1000)/(ISNUMBER($A$5:$A$100)),ROWS($1:1)))
Just Enter
Last edited by JohnTopley; 02-23-2022 at 09:57 AM.
Hi, I get message that there is an error with the formula
Unable to read attachments! Please post the file with errors as requested earlier..
Last edited by JohnTopley; 02-24-2022 at 02:45 AM.
Thank you for your assistance.
Regards
Before going any further, pleas eupdate your profile to show Excel 2016.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
It works perfectly for me. Can you post a file showing it NOT working?
See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks