Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Apostrophe from end of number
I have column with order 500 Records I need to remove the Apostrophe €˜ from
the end of each one can someone please tell me how. 0015762480000' Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Apostrophe from end of number
With your data in column A, in B1 enter:
=LEFT(A1,LEN(A1)-1) and copy down -- Gary''s Student - gsnu200781 "octet" wrote: I have column with order 500 Records I need to remove the Apostrophe €˜ from the end of each one can someone please tell me how. 0015762480000' Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Apostrophe from end of number
Edit, Replace, Find what = ', leave Replace with blank. WARNING: you
will lose the leading "Zeros" so you will need to have formatted the cells as text first. octet wrote: I have column with order 500 Records I need to remove the Apostrophe €˜ from the end of each one can someone please tell me how. 0015762480000' Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Apostrophe from end of number
Hi,
You could use Replace from the Edit menu. Select the first cell in your column. Edit menu Replace You should see the 'Replace' dialog box. In the 'Find What' enter ' (apostrophe) Leave the 'Replace With' line blank. From the 'Search' dropdown, choose Columns Click 'Replace All' Regards - Dave. "octet" wrote: I have column with order 500 Records I need to remove the Apostrophe €˜ from the end of each one can someone please tell me how. 0015762480000' Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Apostrophe from end of number
Thanks everyone
"Dave" wrote: Hi, You could use Replace from the Edit menu. Select the first cell in your column. Edit menu Replace You should see the 'Replace' dialog box. In the 'Find What' enter ' (apostrophe) Leave the 'Replace With' line blank. From the 'Search' dropdown, choose Columns Click 'Replace All' Regards - Dave. "octet" wrote: I have column with order 500 Records I need to remove the Apostrophe €˜ from the end of each one can someone please tell me how. 0015762480000' Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Trailing Apostrophe | Excel Discussion (Misc queries) | |||
how to remove the apostrophe | Excel Discussion (Misc queries) | |||
'09:00AM trying to get remove the apostrophe | Excel Discussion (Misc queries) | |||
Remove apostrophe | Excel Worksheet Functions | |||
Remove the apostrophe (') in Excel cell text values | Excel Discussion (Misc queries) |