Excel: use if to find & change text in column
Solved/Closed
dobeekioskea
venkat1926
- Posts
- 1
- Registration date
- Monday February 8, 2010
- Status
- Member
- Last seen
- February 9, 2010
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel: use if to find & change text in column
- Excel date format won't change ✓ - Forum - Excel
- Excel click on cell to change value of another cell - Forum - Excel
- Excel - Compare two lists and change row color - How-To - Excel
- Excel trigger macro on cell change - Guide
- In excel date format is not changing - Guide
1 reply
venkat1926
Feb 9, 2010 at 04:47 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Feb 9, 2010 at 04:47 AM
suppose a1 to a5 is
305
777
78
82
884
in B1 type thisformula
=IF(LEN(A1)=2,"0"&A1,A1)
copy B1 down
highlight B1 down
edit copy
highlight B1 only
edit -pastespecial-choose values and click ok
now delete column A
do this as an experimetn and you will get hang of i t.
305
777
78
82
884
in B1 type thisformula
=IF(LEN(A1)=2,"0"&A1,A1)
copy B1 down
highlight B1 down
edit copy
highlight B1 only
edit -pastespecial-choose values and click ok
now delete column A
do this as an experimetn and you will get hang of i t.