E
Elle
If one cell states "ra32", how do I get another cell to state "0ra"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=IF(A1="ra32","0ra","")
E
Elle
hi .. i wanted a more generic string.... ie... cell1 could have any two
alphabet letters and any two numbers.... and i want cell 2 to have a zero and
just the two alphabet letters..... does that make sense?
alphabet letters and any two numbers.... and i want cell 2 to have a zero and
just the two alphabet letters..... does that make sense?
T
Toppers
In cell2:
="0" & LEFT(cell1,2)
where cell1 = cell address e.g A1
If you need to check the value:
=IF(Cell1=CompCell,"0" &LEFT(Cell1,2),"")
Where CopCell contains the value to be compared.
HTH
="0" & LEFT(cell1,2)
where cell1 = cell address e.g A1
If you need to check the value:
=IF(Cell1=CompCell,"0" &LEFT(Cell1,2),"")
Where CopCell contains the value to be compared.
HTH
E
Elle
OMG it works!! THANKS!!!!!!!!!!!!
Toppers said:In cell2:
="0" & LEFT(cell1,2)
where cell1 = cell address e.g A1
If you need to check the value:
=IF(Cell1=CompCell,"0" &LEFT(Cell1,2),"")
Where CopCell contains the value to be compared.
HTH