Excel: use if to find & change text in column
Solved/Closed
dobeekioskea
Posts
1
Registration date
Monday 8 February 2010
Status
Member
Last seen
9 February 2010
-
9 Feb 2010 à 01:50
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Feb 2010 à 04:47
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Feb 2010 à 04:47
Related:
- Excel: use if to find & change text in column
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
9 Feb 2010 à 04:47
9 Feb 2010 à 04:47
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.
