Looking for formula to extract texts from cell. See sample file. Thanks
HTML Code:
Looking for formula to extract texts from cell. See sample file. Thanks
HTML Code:
Last edited by bjnockle; 03-09-2020 at 09:27 PM.
what could you offer that would give someone an indication about which items you want?
For example, the first 8 examples the consistent thing to look for is the first space then on row 10 you want the data to the left of the second space, then back to everything to the left of the first space on row 11, then second space on row 12, to the left ignoring the comma on rows 14 and 15 and 17.
It is difficult to write a formula when what you are looking for is inconsistent.
How many of these are there and would a lookup formula based on a table be an option?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sambo kid: Nice observation. It should be consistent on all. I noticed A10 (4 Kido Engr Inc) has space right after 4 instead of no space for consistency (4Kido Engr Inc). We might need a formula to fix this kind of issue before writing the formula we need to extract texts from cell. See revised attached file. Thanks
is 4 Kido a one off or are there more like that potentially in your data? If one off it could be easy to write that into a formula but if there are more like that it becomes more complicated (like 3 Kam and 3Kam).
it is a one (1) off. Thanks.
Last edited by bjnockle; 03-09-2020 at 10:07 PM.
ok, this looks like it works, at least for your sample...
=IFERROR(IF(LEFT(A2,6)="4 kido","4Kido",IF(LEFT(A2,5)="A. M.","A.M.",LEFT(A2,SEARCH(" ",A2)-1))),A2)
Sambo kid: If we do not need to fix any issue, could you please write a general formula that extract the texts. Thanks.
Last edited by bjnockle; 03-09-2020 at 10:23 PM.
Could you put into the workbook what that would look like? It sounds like you want everything but the numbers or you only want the numbers left, not sure which and if that means instead of 1st from 1st Shirt you just want the 1 or just want the st Shirt?
Try this:
Enter formula in B2 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks