concatenation - how to add a prefix to the entire column in m.s office? -
i have data this:
a
1
2
3
i want this
a
x1
x2
x3
i able using '=("x"&a1)' formula , getting in column "b".
a b
1 x1
2 x2
3 x3
but if delete column a, result getting changed. how can expected result?
Comments
Post a Comment