+ Reply to Thread
Results 1 to 3 of 3

Google Spreadsheet-How to split two hyphens in a text into 2 cells?

  1. #1
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Google Spreadsheet-How to split two hyphens in a text into 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

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Google Spreadsheet-How to split two hyphens in a text into 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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    09-18-2021
    Location
    Sweden
    MS-Off Ver
    Google Spreadsheets/2010
    Posts
    59

    Re: Google Spreadsheet-How to split two hyphens in a text into 2 cells?

    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: ..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count total cells in google spreadsheet
    By robert26 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 11-30-2021, 06:06 AM
  2. Replies: 4
    Last Post: 11-11-2015, 03:00 PM
  3. How to convert Text to spreadsheet to Google Calendar
    By wasp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2014, 01:32 AM
  4. Replies: 4
    Last Post: 02-23-2014, 07:32 PM
  5. Help with inserting a link to google maps from cells in a spreadsheet
    By handhglassworks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-21-2014, 09:50 AM
  6. Replies: 10
    Last Post: 03-07-2009, 05:40 PM
  7. Removal of Hyphens from Number or Text formatted cells
    By opsolutions in forum Excel General
    Replies: 2
    Last Post: 01-23-2007, 05:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1