| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove (delete) the first Character in all of the columns
Hi,
How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
=RIGHT(A1,LEN(A1)-1)
copy down as far as needed or Select your range Go to Edit Replace Find What: 1 Replace With: (leave it blank) Replace All " wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
An alternative would be to use DataTextToColumns, check Fixed Width
and set a column separator on the second character. You'd then need to delete the first column, leaving the contents without the first character. Richard wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
Another way is to highlight the offending cells and then use
Edit/Replace (CTRL-H) to find 1 and replace it with nothing. Hope this helps. Pete wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
Rather than importing both columns and deleting the first, it's easier to
tell it "Do not import column (skip)" for the first column. -- David Biddulph "RichardSchollar" wrote in message ups.com... An alternative would be to use DataTextToColumns, check Fixed Width and set a column separator on the second character. You'd then need to delete the first column, leaving the contents without the first character. Richard wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
But be careful if there are other 1's in any of those cells.
Pete_UK wrote: Another way is to highlight the offending cells and then use Edit/Replace (CTRL-H) to find 1 and replace it with nothing. Hope this helps. Pete wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
Good point David :-)
Richard David Biddulph wrote: Rather than importing both columns and deleting the first, it's easier to tell it "Do not import column (skip)" for the first column. -- David Biddulph "RichardSchollar" wrote in message ups.com... An alternative would be to use DataTextToColumns, check Fixed Width and set a column separator on the second character. You'd then need to delete the first column, leaving the contents without the first character. Richard wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
hi,
first u tell me all the remove chracter is if same eg. as per u r example all the remove items is same "1" if all are same my answer is useful ...... if u want to remove first letter "1" just replace it Ctrl +H type find place 1 with replace of nothing u type just replace all ,,,,, thats all u r all first character 1 will be remove........... (This is useful when all the remove character should be same if it is different it wont work fully ) pls try............... Thank u " wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to remove (delete) the first Character in all of the columns
pls try this :
if u r removing character should be same in ur 600 line then only my answer will work if there is any diff it won't work full.. use FIND & REPLACE option go to Replace ........... find place type u r first character replace with ___________ dont type empty u leave click replace all......... so all u r find character should be empty ........ maybe this will help u try.......... " wrote: Hi, How do you remove the first character from all of the columns in an excel spreadsheet ? In the column below - I would want to remove all of the leading 1's. There are over 600 rows in the column. Thanks !! ex: 1dan 1bill 1dill 1sill 1dan 1bill 1dill 1sill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete multiple empty columns in Excel at one time? | Excel Discussion (Misc queries) | |||
| Delete columns simultaneously in several different workbooks | Excel Discussion (Misc queries) | |||
| Search & delete ANY text in select columns | Excel Discussion (Misc queries) | |||
| merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
| Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Linear Mode
