copy first letter to another cell that contain words

[syahputra]

halo
i have table like this

A	B
BG003	Doku Street No.98
AC006	Peter St. No.8

<tbody>
</tbody>

i want to copy cell A to cell B to make it look like this

A	B
BG003	BG003 Doku Street No.98
AC006	AC006 Peter St. No.8

<tbody>
</tbody>

what is the formula i need to save time because it has like 100 rows.
any help would be appreciated
thank you
*sory my poor english

 

[JMonty]

On Column C, enter this formula.

 =A1&" "&B1

Then drag down. Let us know if this helps.

 

[syahputra]

halo JMonty
thank you for the reply

it's not on the colomn C
the code in colomn A has to be copied to colomn B only, before the address

 

[JMonty]

Only a macro can do that. Would you rather use that?

 

[MASHED_33]

Let's tag BG003 as cell A1 and Doku Street No. 98 as cell B1, to make this clear. In cell C1 type =CONCATENATE(A1,B1)

Hope that helps.

 

[Michael M]

Or simply insert a column before column "C", use the formula that JMonty provided.
Then when your satisifed that the data is correct, highlight column "C"
Select Copy, then Paste Special / VALUES ONLY.
Now delete column "B"

 

[syahputra]

Or simply insert a column before column "C", use the formula that JMonty provided.
Then when your satisifed that the data is correct, highlight column "C"
Select Copy, then Paste Special / VALUES ONLY.
Now delete column "B"

thank you very much Michael M
it works

 

[Michael M]

Pleasure, thanks for the feedback....