Excel: use if to find & change text in column
Solved/Closed
dobeekioskea
Posts
1
Registration date
Monday February 8, 2010
Status
Member
Last seen
February 9, 2010
-
Feb 9, 2010 at 01:50 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2010 at 04:47 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2010 at 04:47 AM
Related:
- Excel: use if to find & change text in column
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 9, 2010 at 04:47 AM
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.