+ Reply to Thread
Results 1 to 2 of 2

How do I add (') at the beginning and end of a series of numbers?

  1. #1
    Ann
    Guest

    How do I add (') at the beginning and end of a series of numbers?

    I have a series of 6 digit number that I need to edit to be include (') at
    the beginning and end and then place a (,) after each. Is there a quick way
    to handle this rather than keying on every line, since there are over 400
    lines? EX.
    Before: 123456 After should appear: '123456',
    I have tried to enter the (') in a cell and then concatenate, however the
    (') does not appear in the cell

  2. #2
    Jonathan Cooper
    Guest

    RE: How do I add (') at the beginning and end of a series of numbers?

    use the following helper formula.
    =CONCATENATE("'",A1,"',")

    to clarify, left parentheses, then a double quote, then a single quote, then
    a double quote, then a comma, then A1, then a double quote, then a single
    quote, then a comma and lastly a double quote followed by a right parentheses.

    "Ann" wrote:

    > I have a series of 6 digit number that I need to edit to be include (') at
    > the beginning and end and then place a (,) after each. Is there a quick way
    > to handle this rather than keying on every line, since there are over 400
    > lines? EX.
    > Before: 123456 After should appear: '123456',
    > I have tried to enter the (') in a cell and then concatenate, however the
    > (') does not appear in the cell


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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