Extract data formula

Post Reply
drslim2
Posts: 4
Joined: Sat Jul 13, 2024 9:36 pm

Extract data formula

Post by drslim2 »

Please can someone type out the formula which extracts the data from 2 cells and saves into a third cell as shown in the image.
The data from B and D to be combined into column E

Can anyone help? I am sure its a very simple formula.

Thanks
Attachments
Screenshot 2024-07-13 205029.png
drslim2
Posts: 4
Joined: Sat Jul 13, 2024 9:36 pm

Re: Extract data formula

Post by drslim2 »

Well, this is a useless forum - no responses.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3189
Joined: Wed Mar 11, 2020 5:31 pm

Re: Extract data formula

Post by SuperTech »

Thank you for posting your query, but it's not possible to design such formula in any software like PlanMaker or Excel etc.
wood51
Posts: 3
Joined: Thu May 21, 2020 7:24 am

Re: Extract data formula

Post by wood51 »

You can use "concatenate " or &
drslim2
Posts: 4
Joined: Sat Jul 13, 2024 9:36 pm

Re: Extract data formula

Post by drslim2 »

Hi,
So what would the code be?
Please can you give an example.

Thanks
lgsl
Posts: 163
Joined: Wed Mar 04, 2020 8:00 pm

Re: Extract data formula

Post by lgsl »

drslim2 wrote: Thu Aug 15, 2024 4:47 pm Hi,
So what would the code be?
Please can you give an example.

Thanks
Check Planmaker's manual. There are examples for every formula there.
drslim2
Posts: 4
Joined: Sat Jul 13, 2024 9:36 pm

Re: Extract data formula

Post by drslim2 »

Thanks but I did have a look before posting this question.
However, not everyone has time to become an expert in all things.
Post Reply

Return to “PlanMaker 2021 for Windows”