LinkBack URL
About LinkBacks
For example, I have one cell with 3 cells with values like this, respectively:
1
5; 7; 8; 10
4
and I have a function that add 1 to an integer. How to return 3 cells with values:
2
6; 8; 9; 11
5
without using VBA or manually splitting column?
For example, I have one cell with 3 cells with values like this, respectively:
1
5; 7; 8; 10
4
and I have a function that add 1 to an integer. How to return 3 cells with values:
2
6; 8; 9; 11
5
without using VBA or manually splitting column?
Last edited by koko191; 12-14-2016 at 08:57 AM. Reason: add attachment
can you attach file with desired result in respective cell.
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".
I have added an example. Inside the file are 2 sheets. Column B should be the result of applying a "plus 1" function to column A (in Sheet2 case, it is a capitalize function). The values have to be separated by a semicolon followed by a space character.
Last edited by koko191; 12-14-2016 at 10:01 AM.
try this.
Formula:
Please Login or Register to view this content.
and copy down.
I use that just as an example. What I'm working with is about 10000 lines of mp3 id3v2.3 tags in "a; b; c; d" format and I need to do a bunch of things to them, not just capitalization, but something more complex like reversing artist first name and last name, doing a table lookup and then replacing, etc...
Last edited by koko191; 12-14-2016 at 06:48 PM.
Suppose your name in "A2"
Formula:Please Login or Register to view this content.
What does the formula do? I have just tested it in Excel but I don't really understand what it is supposed to do
It reverses a name
Jagger Mick ==> Mick Jagger
Here is a VBA solution to your need to add 1 to strings: I think this is easiest (only?) option.
To use;
Please Login or Register to view this content.
=Prod(A1)
I wrote a vba script for this. I guess it is impossible to do this without any code after all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks