parse

R

Raman

I have a formula in one cell =e5+0.125
(The second part of the formula is hard coded)
I need to separate it out to =e5 in one cell and 0.125 in
another. What is a good way of doing this?

Thanks
 
J

J.E. McGimpsey

One way:

Select your cell (or a column of cells with similar formulae).

Choose Data/Text to Columns... Select the Delimited radio button and
click Next. In the Other box, enter "+" (without quotes) and click
Finish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement on multiple levels 6
Using IF, AND and OR functions together 2
FAO Mike H - Formula Answer provided 3
Function to Return a Date Value Q 4
Excel does not accept text format! 0
Copy condtional formatting in XL2007 for Windows 1
IF, AND, OR Function 3
Cell reads "Value" without an entry 6

Top