Is their a quick way to turn code into just text

**Nixies** · 09-18-2008, 05:51 AM

Hi

I have a problem. Often I use the commands in Excel to manipulate the text, however I then have to copy the text into excel just to re paste it back into Excel so that it is not code but just text.

Is their any quicker way of doing this. Maybe some function in Excel.

Thanks

Nixies

**rwgrietveld** · 09-18-2008, 05:55 AM

An example would help

**oldchippy** · 09-18-2008, 05:56 AM

Hi,

Welcome to the forum, could you give an example of exactly what you are trying to do?

**Nixies** · 09-24-2008, 04:52 AM

Hmm okay say I have a field in Excel which has the text forumlar:

=A4&" some text"

I want to be able to convert the content of the cell from a forumlar to just be the results. So if the content of A4 was fish. I want to convert the content of the cell from:

=A4&" some text"

to:

fish some text

Is their any quick way of doing this?