Extracting part of Text from one cell to another

  • Thread starter Thread starter Guest
  • Start date Start date
Ron,

I downloaded the morefunc.xll as you suggested. Works perfectly and very
simple to use.

As a relatively new user of Computers, I must thank you and Toppers for
taking the trouble to respond.

This may be another question (if so I will create a new thread), but is
there a way of creating a new Worksheet using the values in the new
cells/columns containing the absolute text & figures without the functions
Click to expand...

Well, you can

1. Insert/Worksheet
2. On the old worksheet (with the formulas) select the range, then Edit/Copy
3. Navigate to the new worksheet
Select the upper left corner of the range
Edit/Paste Special/Values

The above can be automated via a macro, if you need to do this repeatedly.
--ron
 
Thank you

--
JayW, New Milton, Hants, UK


Ron Rosenfeld said:
Well, you can

1. Insert/Worksheet
2. On the old worksheet (with the formulas) select the range, then Edit/Copy
3. Navigate to the new worksheet
Select the upper left corner of the range
Edit/Paste Special/Values

The above can be automated via a macro, if you need to do this repeatedly.
--ron
Click to expand...
 
Thank you

--
JayW, New Milton, Hants, UK


Ron Rosenfeld said:
Well, you can

1. Insert/Worksheet
2. On the old worksheet (with the formulas) select the range, then Edit/Copy
3. Navigate to the new worksheet
Select the upper left corner of the range
Edit/Paste Special/Values

The above can be automated via a macro, if you need to do this repeatedly.
--ron
Click to expand...
 
Ron,

I downloaded the morefunc.xll as you suggested. Works perfectly and very
simple to use.

As a relatively new user of Computers, I must thank you and Toppers for
taking the trouble to respond.
Click to expand...

You're welcome, Jay. Thanks for the feedback.

There are many other useful functions in morefunc.xll too.

Best wishes,
--ron
 
Ron,

I downloaded the morefunc.xll as you suggested. Works perfectly and very
simple to use.

As a relatively new user of Computers, I must thank you and Toppers for
taking the trouble to respond.
Click to expand...

You're welcome, Jay. Thanks for the feedback.

There are many other useful functions in morefunc.xll too.

Best wishes,
--ron
 
Back
Top