how to remove the apostrophe
 

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

how to remove the apostrophe
 

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

how to remove the apostrophe
 

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

how to remove the apostrophe
 

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