| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text in a cell and copy text to another cell
In an excel cell I have the text -
%X400:c=GB;a=Gold 400;p=XXX DRT;s=mslaters;%X500:/o=DFT/ou=DFTU/cn=Recipients/cn=mslatertest I then want to copy the text after SMTP: in the cell but before the % into an adjacent cell I have used the function - =MID(K2,FIND("SMTP:",K2)+5,40) to copy upto 40 characters, so the result is %X400:c= etc but how can I then truncate this or am I on the wrong solution. Thanks in Advance, Shaun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
| Copy text from text box to cell in another worksheet | Excel Worksheet Functions | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| Find text in cell, copy row to new sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
