Insert data in cell

  • Thread starter Thread starter bt707
  • Start date Start date
B

bt707

I have a row of cells that have last names in them, is there a way I can
insert some data into all of the cells, this data will be the same for
all names.

Ex

Before jones1
After (alias=jones1)

then if possible export all of the names to a word or text file all in
one line.

Ex (alias=jones1)(alias=smith2)(alias=johnson3)


Thanks for any help!!!!
 
Is it a row? Insert a new row... In a non related
row enter the text you want added to each. Let's say you
want to add mr. Put cursor in new row.......select fx -
concatenate.....you will concatenate the name in the
original row (Smith) and the cell with the mr and you will
anchor ($A$1). In the new row you will end up with
Smithmr. Copy formula across ........
To make the new concatenated row values, select entire row
and right click copy then select paste special and select
values. remove the original row as now you have your new
row with concatenated data.
 
Back
Top