I have a data as sampled below:
1001- House No. 32 - Paris France
33 - 98 A Germany
86- P-13 St #1 England
I want to apply "Apply text to columns" so that data is divided in just two columns.
1) Data before first "-"
2) Data after the first "-"
The difficulty I am facing is
1) If I use "-" as delimiter, the cell has more than one delimiter converting it into more than required number of cells. (more than 2)
2) If I extract numeric values, it picks up other numbers too. Like House no or street no.
3) The data I need to extract (First Numeric value*) does not have fixed length.
* 1001, 33 and 86 in case of sample data.
Bookmarks