Copy font formatting only for a cell

Hi experts
Look at this image
Untitled.png
The cell is formatted to be in center
with background color
and some parts are in bold and other parts not in bold
some characters are colored and others are not

I needed to copy this cell to another cell but don't want the formatting for all
When I used this I just got the value

Please Login or Register  to view this content.

and when using this I got all the formatting

Please Login or Register  to view this content.

What I need is only the point of bold and not bold
so I don't need background color nor font color nor center position - Just bold and unbold characters

Can't you set the fill and font color to regular after pasting?

I don't understand what you meaned!

If your Data is in Cell G5 and you want to copy it to the first empty Cell in Column J, this might help.

Please Login or Register  to view this content.

thanks a lot for working solution