Copy cell and paste in row below with added character to end of cell

[menmine5]

I have a column of 200 numbered entries and would like to copy the contents of each cell, insert a row below the copied cell and add paste the contents with a "U" at the end of each cell.

Row A1 contains 2124849
Row A2 contains 2124850
Row A3 contains 2124851

I need to be able to copy Row A1 2124849 and insert a row below and paste the contents with a "U". It would look like this:

Row A1 contains 2124849
Row A2 contains 2124849U
Row A3 contains 2124850
Row A4 contains 2124850U
Row A5 contains 2124851
Row A6 contains 2124851U

[HaHoBe]

Hi, menmine5,

work from the bottom up like this:

Please Login or Register  to view this content.

Ciao,
Holger

[Richard Buttrey]

Hi,

There are no doubt a few ways. One relatively simple one is.

1. First select the range A1:A200 and use Data Text To Columns, picking the 'Text' option when you get to it and OK. This will change all the values to Text if they are not already text.

2. Go to A201 and enter the formula

Please Login or Register  to view this content.

and copy it down to A400

3. Select A1:A400 and Sort the column picking the option to 'Sort numbers and numbers stored as text separately'

[menmine5]

Works perfectly... Thanks