conditionally copying cells

G

Guest

Thanks to some great help last week, I am using the below formula to
conditionally copy the contents of cells.

=IF(ISNUMBER(SEARCH("[ Named",C[4])),C[4],"")

I need to expand on this by limiting what is copied from C[4]. I still need
to conditionally copy the contents of the 4th cell over, but I need to ignore
the first 20 characters AND the last 2 characters.

My input data looks like:
[ Named Symbology - T_Gas Meter High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Misc ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Valve High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology
 
D

Dave Peterson

You have lots of replies at your other post.
Thanks to some great help last week, I am using the below formula to
conditionally copy the contents of cells.

=IF(ISNUMBER(SEARCH("[ Named",C[4])),C[4],"")

I need to expand on this by limiting what is copied from C[4]. I still need
to conditionally copy the contents of the 4th cell over, but I need to ignore
the first 20 characters AND the last 2 characters.

My input data looks like:
[ Named Symbology - T_Gas Meter High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Misc ]
001Default TextTextSymbology
002Default PointPointSymbology

[ Named Symbology - T_Gas Valve High Pressure ]
001Default TextTextSymbology
002Default PointPointSymbology
Click to expand...
 

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

Searching for multiple strings and return multiple solutions 2
copy select characters from specified cells. 3
Find and replace a character in a cell with another cell's content 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Array with many cells from a row but not in order or together 11
A Huge Conditional Format Challenge.... 2
After checked condition, add the data to adjacent cell automatically 8
copy conditional formatting across all cells in column 1

Top