Hello everyone.
I've been busting my #$@ trying to find a solution for this, for quite a long time now.
This is how my data is shown, for example, in the spreadsheet: (this language is hebrew)
*תל אביב072-3268099
*ירושלים072-3227610
*פתח תקווה072-3270382
*גבעתיים072-3251498
*חולון072-3250538
*רמת גן072-3223491
*חולון072-3251360
*רמת השרון1599525253
*תל אביב072-3228013
*מזור072-3218041
*פתח תקווה072-3251106
*ראשון לציון072-3268266
*ירושלים02-5333588
as you can see, the number length is not fixed, and sometimes there's a hyphen (-) separating the area code.
I need to find a way to separate the text attached to the numbers.
I'm helpless. The sheet contains about 600 rows.
Any help is welcome.
Thanks
Bookmarks