Get Rid Of The First Symbol

  • Thread starter Thread starter Han
  • Start date Start date
H

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
 
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

Han said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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 -
Click to expand...
 
You could use Find & Replace (CTRL-H) to replace all those commas with
nothing in one operation.

Hope this helps.

Pete
 
Back
Top