excel help?

hardc0re_tid · 4 Jan 2007 at 09:59

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

hardc0re_tid · 4 Jan 2007 at 10:07

hmm, not sure i understand that, can you explain it again please

hardc0re_tid · 4 Jan 2007 at 10:17

Microsoft Excel said:
Microsoft Office Excel found an error...... Do you want to accept the correction proposed below?

=concatenate("90",B2:B4)*7874327766

hardc0re_tid · 4 Jan 2007 at 10:23

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