Hi There,
I'm looking to convert cells of text like this:
https://s28.postimg.org/p871paoel/screenshot_4542.png
Into readable format like:
https://s30.postimg.org/yvr9mfuox/screenshot_4543.png
I did that manually, but wondering if there are ways with excel with some magic to do this automatically.
So combining the text and removing the subtitle time from it.
I have uploaded the worksheet.
Cheers,
Chris
with using =CONCATENATE formula. Like
PHP Code:=CONCATENATE(A7&" "&A11&" "&A15&" "&A19&" "&A23&" "&A27&" "&A31&" "&A35&" "&A39&" "&A43&" "&A47&" "&A51&" "&A55)
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
The simplest CONCATENATE formula to combine the values of cells A1 and B1 is as follows:
=CONCATENATE(A1, A2, A3, A4 )
or
“&” operator
=A1 & A2 & A3 & A4
Thanks for the suggestions, the CONCATENATE function works but the amount of rows i have is over 1000 (see the attached excel document above)
So is there a way to CONCATENATE all of them automatically without needing to put row name e.g. (A1, A2, A3, A4) manually in the formula?
The other one, is there a easy way to remove the subtitle time e.g. 00:00:04 --> 00:00:08 from the output as well?
Cheers.
In that case using vba macro.
Last edited by AliGW; 12-28-2016 at 04:01 AM. Reason: Extraneaous quotation removed & typo corrected.
Thanks, do you know of any good examples on how to do this with vba macro?Originally Posted by avk
Last edited by AliGW; 12-28-2016 at 03:59 AM. Reason: Typo corrected.
@avk - please don't quote whole posts - it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks