Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a cell with a character
I need a way to find the cell containing ":" in a row and copy it to a new
column. I would think it should be simple, I just can't figure it out right now. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a cell with a character
The value function returned a decimal, probably some fraction of the day on
January 1st 1900. So if it is the same as it rounded (I suppose I could have used INT but I used ROUND instead) then it is not the cell I'm looking for. So I ended up with a string of IFs, luckily it was only four columns. I'm sure there has to be a better way. "Dan Kowalski" wrote: I need a way to find the cell containing ":" in a row and copy it to a new column. I would think it should be simple, I just can't figure it out right now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
Find one character or another and display | Excel Worksheet Functions | |||
Find max number of character and return cell address | Excel Worksheet Functions | |||
Find a character to sort on in an Excel cell if not the 1st charac | Excel Worksheet Functions | |||
FIND a character | Excel Discussion (Misc queries) |