Hi guys,
Have this value in cell a1 "zxxxxxx-size-6_8070_10921_e5578cbb1315a1". I would like to move it to b1 automatically to look like "zxxxxxx-size".
Does anyone have a formula for that?
Hi guys,
Have this value in cell a1 "zxxxxxx-size-6_8070_10921_e5578cbb1315a1". I would like to move it to b1 automatically to look like "zxxxxxx-size".
Does anyone have a formula for that?
Try,
B1: =LEFT(A1,FIND("size",A1)+3)
if the format is always like that...blahblah-blahblah-somemorestuff then try this...
=LEFT(A1,FIND("@",SUBSTITUTE(A1,"-","@",2))-1)
If the format is not always that way, please provide some more samples
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I should clarify. The only word that is always in the cell is "-size". Everything before "-size" needs to be moved to the new cell (along with -size"). Everything after it can be deleted.
Hi please see attached for examples.
then berlan's formula should work for you. Did you try the suggestions yet?
They both work on your sample data
Hi, yes Berlans formula worked except..
I need to take it a little further... See the attached.
bump, have I stumped?
Try
=LEFT(A1,FIND("_",A1)-1)
The values in that book DO have 2 _
It's just returning the text up to the 1st one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks