Adding Character Question

[zyx345]

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?

[Gord Dibben]

Combine A1 and C1 with the / in between.

=A1 & " / " & B1 entered in C1

Note the spaces on either side of the /

Drag/copy down Column C or double-click on the fill handle of C1 to copy down.

Copy Column C and in place, Paste Special>Values>OK>Esc

You can delete Column A and B if so desired.


Gord Dibben MS Excel MVP

On Sat, 5 Aug 2006 14:54:58 -0400, zyx345
<zyx345.2c2yxt_1154804107.268@excelforum-nospam.com> wrote:

>
>This is my first post on this forum. Thanks for having me. I have a set
>of data consisting of tracking numbers and locations. For example:
>
>A1 B1
>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:
>
>54321568/ California
>33258469/ Maine
>77894965/ Florida
>
>
>Is there a way to do this?

[zyx345]

That worked! Thanks Gord.

Combine A1 and C1 with the / in between.

=A1 & " / " & B1 entered in C1

Note the spaces on either side of the /

Drag/copy down Column C or double-click on the fill handle of C1 to copy down.

Copy Column C and in place, Paste Special>Values>OK>Esc

You can delete Column A and B if so desired.


Gord Dibben MS Excel MVP[/color]