| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a string in a cell and pasting it in a new column
On Feb 3, 9:52*pm, "Rick Rothstein"
wrote: To Rick, James original post example showed the ID could have any number of hyphens before the string ID. Hmm! So it did (I just went back and looked). Other than not noticing that, I stayed away from the "ID" string, especially in upper or lower case (using SEARCH instead of FIND), out of a worry that those letters could be located in the text, as part of a larger word, in front of the ID text. I guess if they are always upper case, the likelihood of them being in the text before the actual ID is lessened. So, here is my formula modified to look for ID (always upper case) instead of the dash... =MID(A1,FIND("ID",A1),8) I went with James latest post saying that the ID (letters plus following numbers) was always 8 characters long. -- Rick (MVP - Excel) "OssieMac" wrote in message ... yHi James, Did you try the formulas that I posted. The look for the characters ID wherever they are in the string. To Rick, James original post example showed the ID could have any number of hyphens before the string ID. -- Regards, OssieMac "James" wrote: I don't know if I mention this also or not at the beginning *but the ID could be anywhere in the field/cell, at the end or the begining. The only thing that will stay the same is ID with numbers will be 8 characters and each side will be dash to saperate from the rest of the information. Right now we only find it if it is a partuclar place.- Hide quoted text - - Show quoted text - Thanks guys. It works great. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL function;find string in entire column & return cell referenc | Excel Worksheet Functions | |||
| Search for a string, find the column and use that column to sort by | Excel Programming | |||
| Find a string in a column | Excel Programming | |||
| Find a string within a column | Excel Discussion (Misc queries) | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
![James[_45_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
