Thread: Cheat Sheet
View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Is there a better way?


Nope!

I do the same thing. There's just too much to try and remember (especially
for long complex formulas).

Biff

"LMB" wrote in message
...
Hi Guys,

I don't use excel for really complicated things and don't set up sheets
frequently but when I do make a sheet I want a quick way to copy and past
the formulas that I have used in the past. Since I don't do it very
often, is there already a method that you use? Here is an example below
of what I was thinking of. I concatenate text often so this is my first
idea on how to keep track. I created an excel sheet so I can go copy the
formula then change the cell letters to fit what I am working on at the
time. Is there a better way?

Thanks,
Linda


Expression Outcome
=A1&" "&B1 A1String B1String
=A1&", "&B1 A1String, B1String