Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete text in a cell using certian criteria
I have a column with various data in it
How do I delete all the data to the left or right of a certain criteria in this case a -. The data is not aligned so text to columns doesnt work |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete text in a cell using certian criteria
Hi
With your data in A1 the formulas below will retrieve data Left / Right to the "-" =LEFT(A1;FIND("-";A1)-1) =RIGHT(A1;FIND("-";A1)+1) Regards, Per "Ken" skrev i meddelelsen ... I have a column with various data in it How do I delete all the data to the left or right of a certain criteria in this case a -. The data is not aligned so text to columns doesnt work |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete text in a cell using certian criteria
One way: use a blank helper column with formulae dragged down as required
=LEFT(A1,SEARCH("-",A1)-1) for deleting from A1 to the right =RIGHT(A1,LEN(A1)-SEARCH("-",A1)) for deleting from A1 to the left and Copy/PasteSpecial(Values) helper column back to column A! Regards, Stefi Ken ezt Γ*rta: I have a column with various data in it How do I delete all the data to the left or right of a certain criteria in this case a -. The data is not aligned so text to columns doesnt work |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete text in a cell using certian criteria
hi per thanks for the help
i recieve an error message on the formula when i use ";" "Per Jessen" wrote: Hi With your data in A1 the formulas below will retrieve data Left / Right to the "-" =LEFT(A1;FIND("-";A1)-1) =RIGHT(A1;FIND("-";A1)+1) Regards, Per "Ken" skrev i meddelelsen ... I have a column with various data in it How do I delete all the data to the left or right of a certain criteria in this case a -. The data is not aligned so text to columns doesnt work |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete text in a cell using certian criteria
great
"Ken" wrote: I have a column with various data in it How do I delete all the data to the left or right of a certain criteria in this case a -. The data is not aligned so text to columns doesnt work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete part of text from a cell | Excel Worksheet Functions | |||
find cell that contains text and delete entre row | Excel Discussion (Misc queries) | |||
how to sum a repeated val only once and meet a certian criteria? | Excel Worksheet Functions | |||
Delete Spaces and Join Text in Cell | Excel Worksheet Functions | |||
cell input on certian dates!! | Excel Discussion (Misc queries) |