Please see the attached spreadsheet. I need to remove the first 5 x characters from Col A on the Source worksheet (ie. 4 text characters and 1 space), then post the resulting data into Column A of the Target worksheet. In this way, the first data row would look like 'VCE Blended EMEA DF'. Please can someone help?
Thank you
Wendy x
in your Target sheet A2
and copy down
=SUBSTITUTE(Source!A2,LEFT(Source!A2,FIND(" ",Source!A2)),"")
or even this very short formula
=REPLACE(Source!A2,1,5,"")
Last edited by AlKey; 11-11-2014 at 01:22 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
=RIGHT(Source!A2,LEN(Source!A2)-5)
try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Something like this could work for you if your example accurately represents your data
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks