+ Reply to Thread
Results 1 to 8 of 8

Adding hyphens as part of text

  1. #1
    Registered User
    Join Date
    06-22-2022
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    4

    Adding hyphens as part of text

    I've run into a problem in Excel that seems to be a Microsoft "issue," and I am looking for a workaround if anyone has any ideas.

    I have an Excel file that is used as a form for multiple users. One cell is for text where users are writing instructions and often have to include part names, including hyphens. For example:
    "Contractor to provide all labor and materials to provide additional paper towel dispensers (model Bobrick B-318) and change the soap dispensers to the Elite soap dispenser...blah blah blah"
    Excel automatically cuts off all text after the hyphen. In other words, "Contractor to provide all labor and materials to provide additional paper towel dispensers (model Bobrick B" is all that appears in the cell. I have tried adding apostrophes before the "B-318", and before the hyphen itself to no avail.

    Does anyone have any suggestions for formatting this form to allow the multiple users to use it and enter hyphens?

    I appreciate your help.

    Kathleen

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Adding hyphens as part of text

    Unable to replicate the issue. Any chance of seeing a sample file with any sensitive data removed?

    BSB

  3. #3
    Registered User
    Join Date
    06-22-2022
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Adding hyphens as part of text

    Unfortunately, no I can't. My company does not allow that. I am not even on my company computer because a site like this is not permitted to be accessed.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Adding hyphens as part of text

    OK. Can't help then.

    BSB

  5. #5
    Registered User
    Join Date
    06-22-2022
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Adding hyphens as part of text

    I appreciate the offer of help. Have a good day!
    Kathleen

  6. #6
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Adding hyphens as part of text

    Hello,

    What do you meant by 'çut off'? are the remaining text after - split to the cell next to it?

    if so, probably you have used Text to columns to split the text '-' as delimiter.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  7. #7
    Registered User
    Join Date
    06-22-2022
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Adding hyphens as part of text

    Hi there,

    What I mean by cut off is that any text, number, symbol after the hyphen ( - ) disappears from the cell. It does not go to another cell. I can type a paragraph and anything after the hyphen is gone.

    I hope this helps. I never encountered this before and it doesn't happen in other files.
    Thank you!

  8. #8
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Adding hyphens as part of text

    Sorry Kathleen. I don't know the issue then. You can check the following & see if that helps.

    1. Is this only for this file or every file? Open a new file, type your text & see if this occur or not.
    2. Check the file to see if there is any VBA code running on this file.

+ 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] how to extract text between various hyphens or underscores
    By msalib888 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2013, 01:04 AM
  2. [SOLVED] how to extract text between various hyphens or underscores
    By msalib888 in forum Excel General
    Replies: 4
    Last Post: 01-23-2013, 12:55 AM
  3. Adding Text to Formulas - Part 2
    By lwolsiffer in forum Excel General
    Replies: 6
    Last Post: 11-02-2010, 12:10 PM
  4. Replies: 10
    Last Post: 03-07-2009, 05:40 PM
  5. Adding hyphens to hexadecimal?
    By TikisDream in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2008, 06:04 PM
  6. [SOLVED] Remove hyphens in text
    By Pat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-21-2005, 08:05 AM
  7. [SOLVED] How do I format a cell with numbers, text and hyphens
    By Yaya in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 02:06 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