Punctuate text in MS-Excel
Results 1 to 2 of 2

Thread: Punctuate text in MS-Excel
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2018
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Punctuate text in MS-Excel

    Hello,
    I have a thousands of columns of quotations in MS-Excel. I would like to punctuate them. Is there a formula I can use to do it?

    For Example: I would like to change: abc to "abc".

    Thanks in advance.

  2. #2
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,074
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Punctuate text in MS-Excel

    Quote Originally Posted by Beethoven123 View Post
    I have a thousands of columns of quotations in MS-Excel.
    Please clarify... Do you have thousands of columns with thousands of rows of data? Or do you only have several columns with thousands of rows of data? Or do you actually have only one column with thousands of rows of data?

    Why don't you tell use the actual range (starting row and columns involved... we know the number of rows will vary) instead of using a vague description of the range?



    Quote Originally Posted by Beethoven123 View Post
    For Example: I would like to change: abc to "abc".
    Does the text you want to put quotes around (the abc in your example) fill the entire cell that it is in?
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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