Adding Character Question

[zyx345]

This is my first post on this forum. Thanks for having me. I have a se
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 cop
and paste my data into Microsoft Word so it will look like exactl
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 m
data, when pasted into Word look like:

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

 

[zyx345]

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


That worked! Thanks Gord.