LinkBack URL
About LinkBacks
I have eg.
1000, Amerika (USA)
2000, Germany (DEU)
3000, Spain (ESP)
How can i put in another cell with formula:
Amerika (USA)
Germany (DEU)
Spain (ESP)
Thank you
I have eg.
1000, Amerika (USA)
2000, Germany (DEU)
3000, Spain (ESP)
How can i put in another cell with formula:
Amerika (USA)
Germany (DEU)
Spain (ESP)
Thank you
Last edited by Anto_BT; 02-12-2014 at 02:22 PM.
are you just removing the first 6 characters all the time
4th would leave , and space
if so
=mid(a1,7,50)
would remove the first 6 characters - assuming your text starts in cell a1
Last edited by etaf; 02-12-2014 at 02:09 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
here it is
=TRIM(REPLACE(A1,1,FIND(",",A1),""))
1000, Amerika (USA) Amerika (USA) 2000, Germany (DEU) Germany (DEU) 3000, Spain (ESP) Spain (ESP)
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
So i just need everything after "1000, "...
this is not working for me.
Thank you
So i just need everything after "1000, "...
this is not working for me.
Thank you
=TRIM(REPLACE(A1,1,FIND(",",A1),"")) - work's very good.
Thank you very much :D
You're welcome and thank you for your feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks