Hi,
I hope you can help
From cells below I need to remove the last characters as soon as first "-" is found, starting from right
SINV/0086572-87
2307-860098-01
2307-859937-09
I hope this makes sense
Thanks
Vito
Hi,
I hope you can help
From cells below I need to remove the last characters as soon as first "-" is found, starting from right
SINV/0086572-87
2307-860098-01
2307-859937-09
I hope this makes sense
Thanks
Vito
Import your table to Power Query. Split the column of data using the delimeter "-" with one occurance from the right. Delete the split column. Close and Load.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Alan,
Thanks for the message
Is there a formula I can use to achieve this?
Vito
Try this
=LEFT(A1,-LOOKUP(0,-(SEARCH("-",A1,ROW(INDIRECT("1:"&LEN(A1))))))-1)
Thank you, it works
Cheers
Vito
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks