copy data inserting a prefix to copied data

[CPGLH]

I want to copy a column of data to another column with data remaining constant but inserting prefix
e.g.
COL 1 COL2
ABC ZZZ ABC
DEF ZZZ DEF
GHI ZZZ GHI

THANKS

[dilipandey]

Hi CPGLH,

Welcome to the forum.

You can use the below formula:-

="prefix <space>"& A1

OR,

="ZZZ "& A1

If you face any issues, post the sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[jraj1106]

Hello...

You can try this formula too:

=CONCATENATE("ZZZ ",A1)

Regards...