Remove initial

[jad]

HI all,
i have the column names
A.jame
Al.john
td.michael

how can i remove every thing before the . so i can get this result:

jame
john
michae

 

[Frank Kabel]

Hi Michael
in a helper column enter the following formula:
=MID(A1,FIND(".",A1)+1,255)
and copy down

 

[Debra Dalgleish]

You could use the Text to Columns feature:

Select the column
Choose Data>Text to Columns
Choose Delimited, click Next
Add a check mark to 'Other', and type a period in the box
Click Next
In the Data Preview window, click at the top of the first column,
that contains the text before the period
Choose 'Do not import column'
Click Finish

 

[Dave Hawley]

...another way

=REPLACE(A1,1,FIND(".",A1),"")

***** Posted via: http://www.ozgrid.com
Excel Templates, Training,Add-ins & Business Software.
Free Excel Forum http://www.ozgrid.com/forum *****