Get Rid Of The First Symbol

[Han]

A
,B
,A
,C
,D
,A
,B
,B
,C
,D
,A

Hi, Dear Sir or Madam

Could you please show me how to get rid of the first symbnol at each
row using the function and formular?

The result should look like this

A
B
A
C
D
A
B
B
C
D
A

Thanks for your help

Han Chen

 

[Roger Govier]

Hi
One way
=IF(CODE(LEFT(A1))<65,MID(A1,2,255),A1)
Copy down to suit in column B
Afterwards, copy column B>Paste Special>Values to change from Formulae to
your required result.

--

Regards
Roger Govier

A
,B
,A
,C
,D
,A
,B
,B
,C
,D
,A

Hi, Dear Sir or Madam

Could you please show me how to get rid of the first symbnol at each
row using the function and formular?

The result should look like this

A
B
A
C
D
A
B
B
C
D
A

Thanks for your help

Han Chen

__________ Information from ESET Smart Security, version of virus
signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Han]

Thanks, Function Mid will do!

Hi
One way
=IF(CODE(LEFT(A1))<65,MID(A1,2,255),A1)
Copy down to suit in column B
Afterwards, copy column B>Paste Special>Values to change from Formulae to
your required result.

--

Regards
Roger Govier















__________ Information from ESET Smart Security, version of virus signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com- Hide quoted text -

- Show quoted text -

 

[Pete_UK]

You could use Find & Replace (CTRL-H) to replace all those commas with
nothing in one operation.

Hope this helps.

Pete