copy of info that is made using custom format

[DutchKevin]

Hi,
Just out of curiosity I was wondering if and how to do this efficiently.
This is the case.
One of the users here has produced a long list of data.
The data is always build up in equal format. AAAA123456
The 123456 is changing for every line, while the AAAA is changing only a few times over the whole dataset.
The user was smart enough to use custom format to avoid typing AAAA every time.
But.... now we want to use the column elsewhere. With also the leading AAAA.
How do we copy that within Excel, with the leading AAAA?
I know it is possible to copy into eg. Notepad and back to preserve this kind of format info, but isn’t is an option in excel itself?

thanks Kevin

 

[Momentman]

If i get you correctly, in excel 2007 and beyond, i think when you paste, you see the option to keep source formatting, once thats done you shouldnt have any problems......Or even after pasting, you could use format painter to give the new column the formatting of the previous one

 

[DutchKevin]

Hi, thanks for trying to help.
Yes the formatting follows, but I want to copy-paste the full data, without the formatting.
So in my best explanantion, in the source cell only 123456 is typed, it shows then aaaa1232456 based on formatting, but i want to use the aaaa123456 as a pasted value elsewhere.
Does it makeany sense?