Renaming/changing data in a column ...??

**Mtn Breeze** · 01-21-2011, 07:29 PM

Hi all,

I've looked high and low for the answer to this but just can't find it.

I've got a whole heap of GPS waypoint data I have to manage each week. After bringing them into Excel I need to simply put one letter in front of the unique id numbers in one column. I can do it by changing the first cell and dragging it down but because the numbers are not always in sequence I need to be able to just highlight the whole column and somehow put a letter in front of each number in each cell WITHOUT losing that unique number.

Can anyone help this very frustrated Kiwi ??

Thanks,

Matt.

**TMS** · 01-21-2011, 07:38 PM

Maybe a helper column?

If the data is in column A, starting in row 2, you could have:

="x"&A2

and copy down.

Copy the helper column and Paste Special | Values back over column A. Delete the helper column.

You could record a macro to do this if it's a regular feature.

Regards

**Mtn Breeze** · 01-21-2011, 11:19 PM

Thanks for the reply there TM ....

I'm afraid all that is over my head. Someone locally said to use the 'Replace' tool using '?'s to represent the digits and then put the letter I want to add in front and 'replace all'. Tried it all different ways but all I ever get is 'x' ??? instead of 'x' and then the three original numbers ??

Matt.