Remove initial

J

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
 
F

Frank Kabel

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

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
 
Top