Ham-Kam-Molde
Ham-Kam is one team
Molde the other
to use this i will have the text in 3 cells
=SPLIT(O7;"-";TRUE;TRUE)
Ham Kam i want in 1 cell and Molde in another cell = 2 cells
Ham-Kam-Molde
Ham-Kam is one team
Molde the other
to use this i will have the text in 3 cells
=SPLIT(O7;"-";TRUE;TRUE)
Ham Kam i want in 1 cell and Molde in another cell = 2 cells
How do you intend for the spreadsheet to know which hyphens are part of the text string and which hyphens are column delimiters? My first thought would be to identify that criteria, then somehow use that criteria to replace those hyphens with a different delimiter text, then use the SPLIT() function using that new delimiter.
Originally Posted by shg
My knowledge in formulas is Zero and my english sucks too...doublework everytime i need some code...have not much time, i sit and look internet but dont understand much of coding :-\
I think i let my question just be, i dont know when 3 hyphens is coming and only have a special code only for that is not necessary..so let this be solved ;-)
Last edited by KentaTippar; 07-03-2022 at 03:02 AM. Reason: ..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks