Hi Mynda, good morning!
Let me know if you can help me with this problem:
My goal is to extract everything before the first number in Column A of the attached file.
For example:
In cell A1 I have Marina Palace31101001Recepção
So I want to split it and extract only "Marina Palace"
Thanks for your help
Best Regards
José Ricardo
Try the following formula:
=LEFT(A2,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A2&1234567890))-1)
Hi Jose,
In Power Query you can add a custom column and use this formula:
=Text.Start( [Hotel], Text.PositionOfAny( [Hotel], {"1","2","3","4","5","6","7","8","9","0"} ) )
Kind regards,
Mynda
Thanks Mynda!
In fact I was looking for the answer in Power Query.
Could you check what formulas would be appropriated in order to extract everything before the first number in column A?
I started to use Text.PositionOfAny(), but I could not finished.
Best Regards.
José
Sorry Mynda!
Please do not consider my last email.
José
Hi Mynda!
It works perfectly!!!
Thanks a lot!!
