copying cell A1, 10 characters into cell B1 - Partial merging

[andy46]

HI, i have look but not sure the correct terms of what i need

I have some urls i need to redirect for my site and there are hundreds and i wondered if it possible to take whatever is in column A, and paste it 10 characters into column B

e.g., Cell A1 is pasted directly after Redirect / in B1, with http://www.mysite.co.uk/ following. so the end result will be
Redirect /updates/preview.php?p=5&cat_id=0 http://www.mysite.co.uk/

A B 1 updates/preview.php?p=5&cat_id=0 Redirect / http://www.mysite.co.uk/ 2 <tbody> </tbody> cheers Andy

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Oeldere]

Is this what you mean?

Please reply.

Excel Workbook
	A	B	C
1	updates/preview.php?p=5&cat_id=0	Redirect / http://www.mysite.co.uk/	updates/preview.php?p=5&cat_id=0 http://www.mysite.co.uk/
Blad9

Cell Formulas
Range	Formula
C1	=A1 & " "& RIGHT(B1,(LEN(B1)-10))

 

[Teeroy]

Welcome to the forum. It's easiest to build your string in a third column (say C). In C1 put the formula:
=LEFT(B1,10) &A1&MID(B1,11,LEN(B1))
and fill down. To make sure there are no changes when you are finished copy then paste values over the strings created.