Problem with Number to Text Conversion

[vioravis]

I am facing a problem with number to text conversion. In one of the columns, I have the numbers 1,2,3...calculated as 1, A1+1, A2+1,..... When I use Text to columns--> delimited-->text, the numbers in the Column is displayed as 1, A1+1, A2+1, ....and not as 1, 2, 3, .....

Can someone help me in getting the numbers as it is after the number to text conversion?

Thanks.

[swatsp0p]

Your problem is that Text to Columns looks at the actual contents of the cells, not the result. Hence, it 'sees' A1+1, not '2' (the result)

Try this, select your range and 'Copy'. Then (in the same range) Paste Special> Values.

This will replace your formulas with the result.

Now try Text to Columns. Only your numbers are present.

HTH

[vioravis]

Thanks for the reply. But, I am looking for a method without doing cut and paste so that the user can just follow the steps without hassles.

Thanks

[swatsp0p]

I'll be interested to hear if someone has a way to do this without steps to convert your formulas to their resultant values.

I'm also curious as to the reason for doing Text to Columns with this data. There may be other ways to accomplish your goals. What is the final result supposed to look like and what do you desire to do with it?

If all you want is to change these numeric values to text, try this formula and copy down your column:

in B1: =TEXT(A1,A1) assuming your data begins in A1

only the results of the formulas are returned, and formatted as text.

Good Luck

[vioravis]

This is a part of an input to a software. So I do not want the users to do too many changes to the input file and just want a simple procedure that reduces the user's burden. I want the column in text format to look like this:
1
2
3
4
5
.
.
.
.
.

Is there any method to do it?