I am trying to help someone, and the question i have is this. For example,
i have in A1, A2, A3
I would like to separate the last initial from each word, so it would be like
I am new to these formulas, but
i tried this formula =LEFT(A1,LEN(A1)-1)
It takes Mark and puts it in another column
RIGHT(G1,1) would take the Last initial.
Basically my problem is that the above formulas would put them in separte columns, I was wondering if there is a good way to do this, so that the original column is modified, without having new columns for name and initial.
place this mikethebike formula LEFT(A1,LEN(A1)-1) & " " & RIGHT(A1,1)
then Copy it down the 600 rows
Then copy the all of Col b to A but do a Paste special values back to col a
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.