Make the same change to all cells in a column

[Sircrayon]

In Excel, how do I add the same letters to each cell.

For example, I have a list of letters. (a b c d e f g h)

I want to add (.tsx) to each letter to become

a.tsx
b.tsx
c.tsx
d.tsx

How am i able to do this?

Thanks,

[Macdave_19]

Put the letters in your cells then highlight them and run this

Please Login or Register  to view this content.

Cheers

[Macdave_19]

Sorry the sub needs a name of course

Please Login or Register  to view this content.

[Sircrayon]

Hi,

What would be the code if I wanted to do the opposite. For example remove .tsx from all cells that have .tsx at the end?

I appreciate the help

[Sircrayon]

nvm I guess I can just use replace .tsx with blank..haha

thanks for the help!

but out of curiosity what would be the VBA code?

[Macdave_19]

Hi Mate

it would be something like this:

Please Login or Register  to view this content.

It basically saying

Take the cell value
Then take the letter to the left
But only take the letters that are before and including the length of the string (less 4 becuase ".tsx" is 4 characters)

i hope thats clear?

please feel free to leave some feedback by clicking on the scales inthe top right