How to insert some value at a perticular postion

[thenvk]

I have cells in the following way. in each row.


abcd
efgh
a
dfg
erft
vkldfsdas

Now I want to insert some value say XXXXX at the first and last postion(More specifically at a perticular position) in the text). How can I do it?

The end result should be

XXXXX abcdXXXXX
XXXXX efghXXXXX
XXXXX aXXXXX
XXXXX dfgXXXXX
XXXXX erftXXXXX
XXXXX vkldfsdasXXXXX

 

[thenvk]

but that replacements in the adjacent cells are not permanent. You can make them permanent by copying the cells in column B to column A permanently.

How can you do it? I dont think it is possible.

 

[Stormseed]

How can I do, what ? I am sorry but I do not understand your question.

 

[thenvk]

I dont think we can make the changes permanent by removing the references.
As per your above post,When you copy B column to A column, it will not be permanenet as you mentioned.

 

[Stormseed]

If you copy column B and paste special as values to column A, the change would be permanent.

 

[thenvk]

Oh.. too gud, it worked for me ... thanks