Results 1 to 3 of 3

Adding Character Question

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2006
    Location
    Northern, NJ
    Posts
    2

    Adding Character Question

    This is my first post on this forum. Thanks for having me. I have a set of data consisting of tracking numbers and locations. A1 = Tracking Number and B1= Location. For example:

    54321568 California
    33258469 Maine
    77894965 Florida

    I want to insert a character (/) between A1 and B1 then be able to copy and paste my data into Microsoft Word so it will look like exactly this:

    Tracking number (Space) / (Space) Location:

    54321568 / California
    33258469 / Maine
    77894965 / Florida

    I used this formula =(A1&"/") and it worked in Excel but this made my data, when pasted into Word look like:

    Tracking number/ (Space) (Space) (Space) Location:

    54321568/ California
    33258469/ Maine
    77894965/ Florida

    Is there a way to do this?
    Last edited by zyx345; 08-05-2006 at 02:58 PM.

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