HOW TO CONCATENATE TWO CELL(IF ENTERED A AND B DIPLAY AT A)

[how to concatenate]

if have entered in Cell A2 and B2 i want to concatenate in A2 which i have
entered in B2 value also

 

[Max]

Why complicate matters?
Just use another col C to concat
In C2: =A2&" "&B2
Copy down. Then, if needed copy col C and overwrite col A
with a paste special as values, and delete col C.

 

[CLR]

If what you are actually trying to do is to automatically incorporate a
suffix onto a number, (not to TEXT), this can also be done with Custom
Formatting of the cell(s), to the format of

# "YourString"

Otherwise, Max's solution will work just fine, or, if you really want to
automatically CONCATENATE the value from B2 to the value whenever typed in to
A2, then VBA is the only way to do that.

Vaya con Dios,
Chuck, CABGx3