Hello. I'm working on creating a bilingual glossary in Excel. I have the text in the A column as follows (example)
Back freight: Flete de regreso
I want to use a formula that would allow me to have the term "back freigh" in column A and "Flete de regreso" in column B. In other words separating after the colon.
Thanks in advance for your help!
Pat
Hi and welcome to the forum
you have 2 options, text-to-columns or formulas
1. Text-to-columns...
select the range, select T-t-C (Data/data Tools)
select "delimited" and use : as delimiter
It will leave a space at the start of the data in column B
OR use a formula...
in column B, use this, copied down...
=LEFT(A1,SEARCH(":",A1,1)-1)
and then in C, copied down...
=MID(A1,SEARCH(":",A1,1)+2,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Wow. You impressed. Here I was racking my brain with formulas and didn't know that text to column option. That was like magic!
Thanks for your very quick reply. I'm excited to be part of this forum as I try to become more knowledgable about Excel.
Your help was excellent.
Patricia
Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
Hope you read my note though...
It will leave a space at the start of the data in column B
Thanks again. I did try to find the option to mark it as Solved but now I can't find it. And where do I rate the responder? I looked through the FAQ but couldn't find it.Originally Posted by FDibbins
Sorry to bother you with this.
be sure to EDIT your original post - the 1st post in this thread, click Go Advanced and mark the PREFIX box [SOLVED]
Best regard, -)iger-/iger
If you are pleased with a solution mark your post SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks