Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise do no
Hi -
I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise do no
Try
=IF(MID(A1,5,1)="-",RIGHT(A1,(LEN(A1)-5)),A1) "Mike R." wrote: Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise do no
You really should put your main question in the white box, not in the header.
=IF(LEN(A1)<5,A1,IF(MID(A1,5,1)="-",RIGHT(A1,LEN(A1)-5),A1)) -- ** John C ** "Mike R." wrote: Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise dono
Try this:
=IF(MID(A1,5,1)="-",RIGHT(A1,LEN(A1)-5),A1) Hope this helps. Pete On Nov 12, 3:55*pm, Mike R. wrote: Hi - I can't seem to figure this out, I bet it is pretty easy. *Can anyone assist? The text is in A1. Thanks, Mike |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise do no
Firstly, please ask the question in the body of the message. If you ask it
in the subject line, as you tried to do, it will probably be trunc..... By "do no", do you mean include A1 unaltered? By "delete everything to the left" do you mean that you want to output everything to the right of the hyphen? Try =IF(MID(A1,5,1)="-",MID(A1,6,9999),A1) If you want to include the hyphen in the output, and just lose the preceding 4 characters, then try =IF(MID(A13,5,1)="-",MID(A13,5,9999),A13) -- David Biddulph "Mike R." wrote in message ... Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise do no
Hi,
Try =MID(A1,IF(MID(A1,5,1)="-",6,1),99) Cheers, Shane Devenshire "Mike R." wrote: Hi - I can't seem to figure this out, I bet it is pretty easy. Can anyone assist? The text is in A1. Thanks, Mike |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If 5th character="-" delete everything to the left otherwise do no
=MID(A1,IF(MID(A1,5,1)="-",6,1),99)
Stated another way... =MID(A1,1+5*(MID(A1,5,1)="-"),99) -- Rick (MVP - Excel) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |