How to trim cells in MS Excel 2007 column

Hello experts,

I have a column with 1000 rows, which contains the data in the following format:
\\servername\Profiles$\username

I would like to trim it just the username, and would like to get rid of "\\servername\Profiles$\".

Please advise, as to how I can acheive this.

Thanks and regards.
goprasadAsked:
Who is Participating?
 
Brian GeeCommented:
Provided that all the directories listed are administrative shares ($), then a Find and Replace All of *$\ with a blank will perform this operation perfectly.
0
 
wuyinzhiCommented:
maybe you can save all the rows to text, then import/insert the text file to excel, choose "\" as separator, then you will get username in the last column.
0
 
gtkfreakCommented:
You can use the following formula to get the username
=RIGHT(A1,LEN(A1)-(FIND("$",A1))-1)
where A1 = \\servername\Profiles$\username
0
 
Brian GeeCommented:
Like below:  

Replace All
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.