Hi,
I have a huge sheet with 2000+ rows.
And I need to subtract the text in A1 from the text in B1.
A1:
AL-ARZ ICE CREAM FACTORY CO.
B1:
Al-Arz Ice Cream - BT-C / GMF / GIF 1200
Outcome should be:
BT-C / GMF / GIF 1200
Please help,
BR
Peter
Hi,
I have a huge sheet with 2000+ rows.
And I need to subtract the text in A1 from the text in B1.
A1:
AL-ARZ ICE CREAM FACTORY CO.
B1:
Al-Arz Ice Cream - BT-C / GMF / GIF 1200
Outcome should be:
BT-C / GMF / GIF 1200
Please help,
BR
Peter
You get better help if you add an small excel file without condicential information.
Please also add manualy the expected result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
How do I add a file to my post??
Or in this case after I added my post?
1. It would help to see the workbook.
To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
Sheet with example of problem
Thank you
See the question in #2.
Please also add manualy the expected result in your file.
Sorry, thought I did that already.
/Peter
Your data is not consistent.
See the attached file to see the green cells (The best I came with).
=IF(LEFT(TRIM(MID(B2,LOOKUP(9^9,SEARCH(LEFT(A2&" ^",ROW($1:$256))&" ",B2),ROW($1:$256))+1,256)),1)="-",MID(TRIM(MID(B2,LOOKUP(9^9,SEARCH(LEFT(A2&" ^",ROW($1:$256))&" ",B2),ROW($1:$256))+1,256)),3,256),TRIM(MID(B2,LOOKUP(9^9,SEARCH(LEFT(A2&" ^",ROW($1:$256))&" ",B2),ROW($1:$256))+1,256)))
SEE THE ATTACHED FILEPlease Login or Register to view this content.
It is not working for all the cases
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thanks a lot.
It seems to be working, just have to clean up my data a bit for it to work on all cells.
Again, thanks.
@Rennurg
Since you get anwers of several forummembers it is Always good to add to who you are replying.
Which solution did you choose?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks