Convert text to number?

[Sean Anderson]

Hello all,

Is it possible to extract a number from a text string, then use that number in a computation? Then spit the result back out as a text string?

Here's the scoop.

Step 1: The user types a number into cell A1. Let's use 99 for this example.

Step 2: Excel concatenates the word "Years" with the number 99, then displays "99 Years" in the selfsame cell A1. (This is probably a weird request, but I have my reasons)

Step 3: In cell B1 is a formula that adds 1 to whatever number was typed into cell A1. In this example the result would be 100.

Step 4: Then Excel displays "100 Years" inside cell B1.

What would be the formula to make this happen? Any ideas? Thank a mill.

[jasoncw]

Hi, Sean.

Select cell A1, then go to Format > Cells. In the number tab, select Custom, then in the Custom box type in:

0" Years"

Now any number typed into A1 will be X Years.

In cell B1, just use:

=A1 + 1

B1 may also need to have the custom format applied as stated above.

HTH

Jason

[Sean Anderson]

Wow that was simple. Thanks a bunch.

[jasoncw]

No problem.