excel help?

hardc0re_tid

hardc0re_tid

hardc0re_tid

Soldato
Joined
4 Nov 2004
Posts
3,040
Location
Norn' Iron'
is there a quick way to change the contents of multiple cells in excel.

i have a list of numbers, but they all need to have the numbers '90' infront of them. there are 400 entries but it will take too long to manually put '90' infront of each entry. is there anyway to do this? eg. select all cells in the column and 'insert' '90' infront of cell contents
 
=concatenate("90",a1)
change a1 for whatever cell your text is in, this will give you a column with those numbers in, to change them to text rather than forumula copy and paste to notepad and then backagain.

just drag the formula down to the length of your row of numbers
 
you need to put this formula in a new column, in the cell level with the one your data starts in.

eg your data is in a2:a102 so you will put the formula in the next empty column eg d2. so in d2 put... =concatenate("90",a2) and drag the formula down to d102

obviously you need to change the cell reference to the one which you are using.
This will join 90 to the beginning of cell a2 (unless changed), although the output will look right in excel it will be a formula, but if you select all the cells with that formula in, copy them, open notepad, paste them in, you will have the 90 followed by your number in text, then be able to paste that back into excel.
 
never worry, got it sorted, the text doesnt appear in the colum as it is white, selected the column and changed text to black

thanks for your help
 
You must log in or register to reply here.
Back
Top Bottom