[Solved] Need function to change X1 X1 X1 to X1 X2 X3

Discuss the spreadsheet application

[Solved] Need function to change X1 X1 X1 to X1 X2 X3

Postby AlexandraNyx » Thu Jan 23, 2020 6:43 pm

hello kind people

I changed column A to look like column C.
I did it manually

Problem is there are thousands of these.

Is there a function put into a helper column that can do the trick?
most appreciative of any insight!

sheet posted
Attachments
formula for changing A into C thanks!.ods
Changed title, was: Need a function
(12.08 KiB) Downloaded 17 times
Last edited by AlexandraNyx on Thu Jan 23, 2020 11:23 pm, edited 1 time in total.
OPEN OFFICE 4.1.1 ON WINDOWS 7
AlexandraNyx
 
Posts: 50
Joined: Sat Mar 21, 2015 9:13 pm

Re: need a function

Postby FJCC » Thu Jan 23, 2020 7:05 pm

I am sorry, I do not understand what you want to do. You say you changed column A to look like column C but the two are not always equal. For example, they differ in row 5. Does it not work to put in A2 the formula
Code: Select all   Expand viewCollapse view
=C2

and then copy that down the whole column?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7751
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: need a function

Postby F3K Total » Thu Jan 23, 2020 7:14 pm

Hello
D2:
Code: Select all   Expand viewCollapse view
=IF(ISBLANK(A1);1;D1+1)

E2:
Code: Select all   Expand viewCollapse view
=IF(ISBLANK(A2);"";LEFT(A2;3)&D2)

Pull down
Works only if your codes have lenght 4 and only till 9 per block.
R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer
 
Posts: 977
Joined: Fri Dec 16, 2011 8:20 pm

Re: need a function

Postby AlexandraNyx » Thu Jan 23, 2020 10:55 pm

To FJ

Thanks for the answer. 2pW represent a result. The 1 represents the number of times for this particular result. If the same result happens more than once I have to change the 1 to 2 or the number of times in a row it happened - thus, that's what C represents. Me changing A.
OPEN OFFICE 4.1.1 ON WINDOWS 7
AlexandraNyx
 
Posts: 50
Joined: Sat Mar 21, 2015 9:13 pm

Re: need a function

Postby AlexandraNyx » Thu Jan 23, 2020 11:04 pm

To FK3

Love you brother. Works fantastic. I do have some that are over 9 but this is great. Super happy.

bless you my friend
alexandra
OPEN OFFICE 4.1.1 ON WINDOWS 7
AlexandraNyx
 
Posts: 50
Joined: Sat Mar 21, 2015 9:13 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests