Return Carriage

[exceldummy]

I am looking to create a formula that I can copy and paste into Reynolds Accounting software.

for Example:
A1 [enter] A2 [enter] A3 [enter]

I don't want the information to formulate - just condense in a way I can copy and paste it into my software without having to type each cell individually but my software requires a return between each information.

Anyone amazing enough to solve this problem?! ps. ALT+enter and char(10) do not work unless I am just formatting wrong.
Do I need to build a macros? How would that look?

 

[Andrzejek]

Just a guess here, but did you try:

A1
A2
A3

???

There is a Return Carriage at the end of each line. It works fine if pasted to Excel or Word or Notepad....

Have fun.

---- Andy

 

[exceldummy]

Yes I tried and no it didn't work wouldn't actually carry over to the next field in my software but put all the information into the first field

 

[Andrzejek]

Another guess, TAB instead of Enter....:

A1 [[]TAB] A2 [[]TAB] A3 [[]TAB]


Have fun.

---- Andy

 

[SkipVought]

Try...

COPY cells in Excel

PASTE into NotePad

COPY what you just pasted from NotePad

PASTE into your software.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Gavona]

Another guess at what your software really needs:
Assuming you are starting in Excel then you could simply try consolidating your separate cells into one with a HardReturn character in between. Then copy and paste into your accounting software.
="text1"&CHAR(13)&"Text2"

Interestingly the result of this formula appears to ignore the hard return char(13). However if you paste into another application you see the hard return. And if you test =len(A1) you find there are 11 characters and the 6th is indeed char(13) = mid(a1,6,1)
="text1"&CHAR(13)&"Text2"



Gavin

 

[exceldummy]

Skip that worked! Now....is there a way to remove the parenthesis which i think it where my system is having the trouble. When I copy and paste the info to notepad it looks like:

"B110[]162.76[]8991"

Which means if I have 20 rows of information I still have to select each row individually..is there a way to tell excel not to do the parenthesis so that when I copy and paste into notepad so that it looks like...

B110[]162.76[]8991
B110[]70.26[]8990
B110[]57.10[]8989

??

 

[Gavona]

In notepad you can do an edtit, replace with nothing

Gavin

 

[SkipVought]

There must be BRACKETS in a formula or as text.

SO WHAT!

Copy the whole thing into NP (ALL ROWS/COLUMNS)

Then 2 Edit/Replace operations.

And then the world is @ peace!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[exceldummy]

You guys are awesome, just saying!

I can do that and it seems to work just fine. Wish there was a way to build it into excel so it was one less step but if there isn't this solution will surely work.

 

[SkipVought]

So how often do you have to do this?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[exceldummy]

Well I don't know how familiar you are with acounting but its for a journal entry to make an adjustment to an account which is being done daily if not a few times a day

 

[Gavona]

I would expect that there is a way. ~I suggested:
="text1"&CHAR(13)&"Text2"
Try adapting that:
=a1&"[]"&a2&"[]"&a3
Though I am lost as to your requirements. Do you or do you not need parenthesis (those square brackets)? Where in the solution you have now is the return character and what is its ascii code?


Gavin

 

[webrabbit]

My son is an accountant and has to do this type of thing all the time. He has found an applet that can automate any task. When the company he worked for went through bankruptcy, he had to update 500,000 journal entries. He logged onto the system from home and watched television while his computer did the work.

If you would like, I could get the name of the applet and post it, perhaps even a link.