Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
i have a column that contains 8 digit code. However, the front starts with '12345678. May i know how to remove the apostrophe ('). Kindly advise. Thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try selecting the column then choose Text-To-Columns on the data menu,
and click Finish. On 11 Apr, 09:24, Tiffany wrote: Hi i have a column that contains 8 digit code. However, the front starts with '12345678. May i know how to remove the apostrophe ('). Kindly advise. Thank you |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On 11 Apr, 09:53, "Lori" wrote:
Try selecting the column then choose Text-To-Columns on the data menu, and click Finish. On 11 Apr, 09:24, Tiffany wrote: Hi i have a column that contains 8 digit code. However, the front starts with '12345678. May i know how to remove the apostrophe ('). Kindly advise. Thank you- Hide quoted text - - Show quoted text - Or if you prefer to do it with a formula, you could use =VALUE(A1) Regards Phil |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Do the following:
1. Select the column heading to select complete cells with the column. Column cells that has text format appears aligned to the left. 2. On the Data menu, click Text to cloumns. The Convert Text to Columns wizard is displayed. 3. Click Finish in the Step1 of 3 in the Convert Text to Columns wizard dialog box. All numbers aligns to right. This shows that the format for all the cells are numbers. Challa Prabhu "Lori" wrote: Try selecting the column then choose Text-To-Columns on the data menu, and click Finish. On 11 Apr, 09:24, Tiffany wrote: Hi i have a column that contains 8 digit code. However, the front starts with '12345678. May i know how to remove the apostrophe ('). Kindly advise. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Apostrophe Mayhew | Excel Worksheet Functions | |||
'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) | |||
Add apostrophe | Excel Worksheet Functions |