Need to convert list of formulas in text format to output value

[mcmilja]

I have a very large list of formulas in text format so the formula isn't
providing an output. I have to change the cell format from text to general
and I have to click on the cell that contains the formula and then click on
the formula bar and hit enter for the formula to work. I have a very large
list of formulas in my worksheet so is there an easier way to do this?

Here is how the formula actually looks in the cell
='\\gaalpfps10\TN-Shared\Network\Network\Traffic\FrameLayouts\WTN\[WTN-501-Friendship.xls]Changes'!a3

Thanks!

Jaret

 

[Dave Peterson]

Select the range to fix
Change the numberformat to General

With that range still selected
Edit|replace
what: = (equal sign)
with: =
replace all

I have a very large list of formulas in text format so the formula isn't
providing an output. I have to change the cell format from text to general
and I have to click on the cell that contains the formula and then click on
the formula bar and hit enter for the formula to work. I have a very large
list of formulas in my worksheet so is there an easier way to do this?

Here is how the formula actually looks in the cell:
='\\gaalpfps10\TN-Shared\Network\Network\Traffic\FrameLayouts\WTN\[WTN-501-Friendship.xls]Changes'!a3

Thanks!

Jaret

 

[Sheeloo]

Assuming your formulae are in Col A...

Select Col A
Choose 'Text to column' option under 'Data'
Choose Fixed Width, make sure that output is one column only (if necessary
increase the Col width)
Press FINISH

I don't think changing the format to General is required but you can do that
for the whole Col at one go.

 

[Gary''s Student]

Say you have formula in column A from A1 thru A100. Hi-light the cells and
pull-down:

Data > Text to Columns...

and then map the column onto itself. The formulas will become "real".

 

[mcmilja]

Dave, you da man! That worked like a champ!

Jaret

Select the range to fix
Change the numberformat to General

With that range still selected
Edit|replace
what: = (equal sign)
with: =
replace all

I have a very large list of formulas in text format so the formula isn't
providing an output. I have to change the cell format from text to general
and I have to click on the cell that contains the formula and then click on
the formula bar and hit enter for the formula to work. I have a very large
list of formulas in my worksheet so is there an easier way to do this?

Here is how the formula actually looks in the cell:
='\\gaalpfps10\TN-Shared\Network\Network\Traffic\FrameLayouts\WTN\[WTN-501-Friendship.xls]Changes'!a3

Thanks!

Jaret

 

[mcmilja]

Thanks Sheeloo.

Assuming your formulae are in Col A...

Select Col A
Choose 'Text to column' option under 'Data'
Choose Fixed Width, make sure that output is one column only (if necessary
increase the Col width)
Press FINISH

I don't think changing the format to General is required but you can do that
for the whole Col at one go.

I have a very large list of formulas in text format so the formula isn't
providing an output. I have to change the cell format from text to general
and I have to click on the cell that contains the formula and then click on
the formula bar and hit enter for the formula to work. I have a very large
list of formulas in my worksheet so is there an easier way to do this?

Here is how the formula actually looks in the cell:
='\\gaalpfps10\TN-Shared\Network\Network\Traffic\FrameLayouts\WTN\[WTN-501-Friendship.xls]Changes'!a3

Thanks!

Jaret

 

[mcmilja]

Thank you.

Say you have formula in column A from A1 thru A100. Hi-light the cells and
pull-down:

Data > Text to Columns...

and then map the column onto itself. The formulas will become "real".
--
Gary''s Student - gsnu200835

I have a very large list of formulas in text format so the formula isn't
providing an output. I have to change the cell format from text to general
and I have to click on the cell that contains the formula and then click on
the formula bar and hit enter for the formula to work. I have a very large
list of formulas in my worksheet so is there an easier way to do this?

Here is how the formula actually looks in the cell:
='\\gaalpfps10\TN-Shared\Network\Network\Traffic\FrameLayouts\WTN\[WTN-501-Friendship.xls]Changes'!a3

Thanks!

Jaret