Need to change data entered into cell. HELP ASAP!!

[Nadia]

I have a list of over 7000 unique numbers (i.e. 123 or 77-
123). I need to add the letters "MH" in front of each
number. Is there an easier way to do this than to click
and edit each individual cell manually? Please help,
anyone have any suggestions? Lots of thanks in advance.

 

[Frank Kabel]

Hi
one way (if you only have numbers): use acustom format :
"MH"0

another way:
in the adjacent column in row one (lets say in B1) enter the formula
="MH" & A1
copy this formula down

After this select column B and copy the contents (CTRL+C). goto 'Edit -
Paste Special' and insert the content as 'Values' to remove the
formulas

 

[JE McGimpsey]

In an empty column (say J), enter, assuming your numbers are in column A:

J1: ="MH" & A1

Copy down as far as necessary. Select Column J and Copy. Select Column A
and Edit/Paste Special/Values.

 

[Nadia]

Thank you so much...I knew there had to be an easier way.

 

[Bill j]

alternately you could select the column and use pull down

 

[JE McGimpsey]

True if you just want to change the display of the data. The OP indicate
that there was a "need to change data", though. Perhaps reading too much
into it.